LinkBack URL
About LinkBacks
Excel_vba 
I can't figure out how to do this.
I can't figure out how to do this.
Yes
Try For Each r in lastcell to 1 Step -1
As the first line in your loop.
Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.
When you reply please make it clear WHO you are responding to by mentioning their name.
If we have been of assistance, please let us know. A little thanks goes a long way.
- Please click on the *Add Reputation button at the bottom of helpful responses.
Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".
You mean, like:No
For Each cell in Range("A1:A20")
you'd need to say:
Dim i As Long For i = 20 To 1 Step -1 Range("A" & i).Value = i Next 'i
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks