Hello. I'm trying to put a for loop to increase the i by 1 for each copy and paste. I'm not sure how to do it though. Please help.
Please Login or Register to view this content.
Hello. I'm trying to put a for loop to increase the i by 1 for each copy and paste. I'm not sure how to do it though. Please help.
Please Login or Register to view this content.
You already have a loop, if you only want to increase i by one each time just add this as the first line in the Case Else code.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Maybe:
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks