Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying a sheet fails
I have a line that copies a sheet from one book to another. It works a
number of times in my macro then inexplicably stops working. The line is: ActiveSheet.Copy Befo=Workbooks(NewBookName).Sheets("XXX") And I get the error: 1004 "Copy method of worksheet class failed" It stops when I try to add the 54th sheet in a workbook - I don't know if that number is significant. There is no problem with the string: 'NewBookName' or the sheet named 'XXX' (as I say the line works 52 times) But suddenly I get an error Anyone seen this before? Thanks M |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Select a Sheet Issue in VBA on a very hidden sheet - fails | Excel Programming | |||
Validation fails on copying | Excel Discussion (Misc queries) | |||
Copying Conditional Formatting Fails | Excel Programming | |||
Activate fails when someone else is in the sheet | Excel Programming | |||
Copy to another sheet fails | Excel Programming |