Running macro specific # of times

[The Skipper]

Please........can someone advise code to make a macro run a specific number of times?

Much appreciated......thanks

[tigeravatar]

The Skipper,

Something like this should work:

Sub tgr()
    
    Dim i As Long
    
    For i = 1 To 10 'Replace 10 with your specific number
        Call MacroName
    Next i
    
End Sub

[The Skipper]

Thanks.....I'll give it a try.

[The Skipper]

Should I put your code in the macro I want repeated?

[tigeravatar]

The code is designed to run as its own macro. You would replace MacroName with the name of the macro you want to have repeated. If you want the repeat code to be a part of your existing macro:

Sub MacroName()
    
    Dim i As Long
    'Here is your existing macro's variable declarations
    
    For i = 1 To 10
        
        ''''''''''''''''''''''''''''
        '                          '
        '   Your macro code here   '
        '                          '
        ''''''''''''''''''''''''''''
        
    Next i
    
End Sub