Subscript out of Range indicates that VBA cannot find an Object with the
name used. Check your spelling and be sure the name you use exists.



"sam" wrote in message
...
I got a subscript out of range error when trying to copy sheet2. Sheet2 is
hidden.

here is the code:

Worksheets("Hidden").Copy Worksheets("Sheet2")

Thanks in advance