LinkBack URL
About LinkBacks
I have recorded this code, but need the range to vary by the number of rows in the worksheet.
How do I rewrite this?
Please Login or Register to view this content.
I have recorded this code, but need the range to vary by the number of rows in the worksheet.
How do I rewrite this?
Please Login or Register to view this content.
Last edited by Cutter; 07-22-2012 at 03:35 PM. Reason: Added code tags
To get the row number last used row in a column use:
Replace the ? with the Column Letter.Please Login or Register to view this content.
Last edited by Cutter; 07-22-2012 at 03:35 PM. Reason: Added code tags
Ben Van Johnson
I know Ben has already posted but I had already typed the code so I might as well post it. It gives the end result that your code had but I am a bit puzzled what you intended with the AA2 part ofRange("AA2:AE2").SelectorPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by WasWodge; 07-22-2012 at 03:34 PM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Thanks all! I sure all of these will work great.
P.S. Column AA was the first uninterrupted column that got me to the bottom of the list without stopping between blank cells or to the bottom of the sheet.
That explains it. Please note only use the first code I posted if AE2 is a value and not a formula. You do also have the option of autofill which would be
Depends what suits bestPlease Login or Register to view this content.
Thanks WasWodge!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks