Need a code to only run a command every 10 loops

[thuddleston11]

I keep getting Run Time Error 1004 and I think if I can figure out a code to do the following it will stop. I want the workbook to save, close and reopen and restart the macro (control z) when the workbook reopens.

I can figure out the code.Our Bed Board.xlsm

[HaHoBe]

Hi, thuddleston11,

please do not start multiple threads on the same topic (http://www.excelforum.com/excel-prog...-10-loops.html) - thanks.

Ciao,
Holger