subscript out of range error: tyring to copy a hidden sheet
 

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

subscript out of range error: tyring to copy a hidden sheet
 

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