subscript out of range error: tyring to copy a hidden sheet
You shouldnt need the "hidden"
"sam" wrote:
Worksheets.Copy Worksheets("Sheet2") should work fine
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
|