ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   copy method of worksheet class failed: trying to copy a hidden she (https://www.excelbanter.com/excel-programming/432172-copy-method-worksheet-class-failed-trying-copy-hidden-she.html)

Sam

copy method of worksheet class failed: trying to copy a hidden she
 
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


All times are GMT +1. The time now is 07:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com