C
Carter
I have a copy command in a loop. I copy a sheet after a numbered sheet in
the loop. After 21 copies I get Run time error '1004': Copy method of
worksheet class failed and the macro stops. I have tried the
Application.CutCopyMode = False statement and it doesn't seem to help.
Any suggestions???
the loop. After 21 copies I get Run time error '1004': Copy method of
worksheet class failed and the macro stops. I have tried the
Application.CutCopyMode = False statement and it doesn't seem to help.
Any suggestions???