You will get that message when you copy a hidden sheet without specifying
Befo= or After:=. If the sheet is not hidden, it will create a new
workbook with only that sheet in it.


"sam" wrote in message
...
I got a "copy method of worksheet class failed" error when trying to copy
sheet2.
Sheet2 is hidden.

here is the code:

Sheets("Sheet2").Copy

Thanks in advance