Thread: Create a loop to call macro a specified number of times

Hello magito,

Welcome to the Forum!

If you have a macro written then you should post the code. This will help in developing a workable solution.

Hi magito

Welcome to the Forum. Please post at least the code you have...a sanitized workbook would be better. This'll give us a clearer picture of what you'd like to accomplish.

Thanks for your responses - The code for my macro is below. Essentially what I am trying to do is to add code to create an input box which will allow a user to enter the number of times the code below will repeat itself. The template has two lines to start with (on 3 worksheets) so the result I am seeking is for the macro to run the number of times entered minus 2 so the number of lines will equal the number entered.

I am confused on how to compare the input value with the value of the counter in my spreadsheet which is a countif function. I think this can be accomplished with an if then statement which determines if the macro should end or call the sub in the code below to add another row.

Thanks in advance for your help

Application.Goto Reference:="Input_Add"
    Selection.Insert Shift:=xlDown
    Application.Goto Reference:="Class_Sample"
    Selection.Copy
    Application.Goto Reference:="Class_add"
    Selection.Insert Shift:=xlDown
    Application.Goto Reference:="Acct_Sample"
    Application.CutCopyMode = False
    Selection.Copy
    Application.Goto Reference:="Acc_Add"
    Selection.Insert Shift:=xlDown
    Application.Goto Reference:="Input_Add"
    
End Sub