Please help with macro -
Posted by Quinn on January 26, 2001 7:37 PM
I have a macro that unhides a hidden master sheet,copies the sheet, and then hides the master again. It works perfectly for about 39 sheets. Then I get a Run Time Error'1004: Copy method of worksheet failed. If I save the file, close it and reopen it, It will then allow me to continue for another 20 sheets and I receive the same Message.
Is there a fix for this problem? The code I have follows:
Sheets("Wall ").Visible =True
Sheets("Wall ").Visible =False
Should I be doing anything with the screen? I can watch it go through the steps while the macro is running -and I would rather not see it.
Thanks for any help.