I have a macro that loops For i = 2 To 17, where row 17 is the last row of data.
Dim i as Integer
For i = 2 To 17
Do something
Next i
However, my last row of data changes everyday. How can I modify the macro such that I can loop it until the last row?
Please use Code Tags for your code excerpts.
If you have a column that is fully populated, that is, it has an entry for every row ... or, at least, a guaranteed entry in the last row of data, for example, column A, you can use this:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Very easy if there is a column in your data that is always filled. Say column A always has data. Then:
Please Login or Register to view this content.
Gary's Student
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks