Looping Recorded Macro

[mattyh555]

Good Day,
I have a recorded macro that I would like to get an input from the user of how many times to run the macro.

Please Login or Register  to view this content.

I get a run-time error '1004' - Insert method of Range class failed at the code in red.

Any ideas?

[TMS]

Works fine for me ... but I don't have a workbook or data to test it with.

Is the worksheet protected?


Regards, TMS

[mattyh555]

Yes it was protected. I will work in the code to unprotect it on running of the macro and to protect it again after it is complete.

Thanks so much.

[TMS]

You're welcome.