Repeat a Macro

[sacohen]

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.

Thanks;

Steve

[peternlewis]

See:

Variable Repeat

The numeric field in the Repeat loop, like pretty much all numeric fields in Keyboard Maestro, can contain an expression, which can also include variables or functions. Here is an example showing how you can repeat a variable number of times. [image] Note that "Count" in the Repeat action will show up in red until it has a valid numeric value (usually when you run the macro the first time and enter the value in the Prompt. You can select the Prompt For User Input action, and click the Try bu…

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.