I’m trying to find a way to repeat a Macro I have “Macro 1234” until I get to the end of an excel spreadsheet that I have.
The spreadsheet has 279 entries right now, but it does change weekly.
I tried placing the Repeat Action at the end of the macro and entered in the number of time I want it to repeat. IE: 279.
I never ended, because it kept getting to the end of the macro and repeating.
I tried making a new Macro that called my “Macro 1234” and looping that, but it didn’t work either and I can’t remember why right now.
Any help is appreciated.
To use the Repeat action, configure it with the count you want to repeat (which you could ask the user about as shown in the example above), and place the actions you want to repeat within it.