I know how to loop using this code Sub WorksheetLoop2() Dim Cur As Worksheet For Each Cur In Worksheets '===================== 'This line calls for recording of the actions '====================== Next End Sub What I am asking for is a macro that will call of a recording of actions and after pressing a particular key, it stops the recording and loop afterwards.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro to call for recording and then loop

Thread starter yinkajewole
Start date May 9, 2019
Tags

actions cur loop macro recording

yinkajewole

Active Member

May 9, 2019

I know how to loop using this code

Code:

[COLOR=#000000][FONT=Consolas]Sub WorksheetLoop2()[/FONT][/COLOR]<code class="" style="box-sizing: inherit; font-family: Consolas, 'Courier New', Courier, monospace; font-size: 1em;">     Dim Cur As Worksheet
     For Each Cur In Worksheets
     '=====================
     'This line calls for recording of the actions
     '======================
     Next

</code>[COLOR=#000000][FONT=Consolas]      End Sub[/FONT][/COLOR]

What I am asking for is a macro that will call of a recording of actions and after pressing a particular key, it stops the recording and loop afterwards.