I don't see all of my original code here but
also give me meaning of "r = Cells(Rows.Count, "J").End(xlUp).Row "
Excel is looking in col J for the bottom most cell, ie 22
Range("J2:J" & r) in above code.
Excel is using range("j2:j22")
makes little difference what r is called. could be lastrow or x or many
things as you desire
-----Original Message-----
From: airen
Sent: Thursday, September 29, 2011 9:00 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Create worksheet from list
Hi dguillett,
I am a learner, could you please tell me meaning of "& r" in
Range("J2:J" & r) in above code.
Thanks
Akhilesh Airen
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
