ExcelBanter - copy a hidden sheet

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - copy a hidden sheet (https://www.excelbanter.com/excel-programming/294639-copy-hidden-sheet.html)

TimS

copy a hidden sheet

any advice appreciated. - how can i copy a hidden sheet to a new workbook?

Bob Phillips[_6_]

copy a hidden sheet

Worksheets("Sheet1").Visible = True
Worksheets("Sheet1").Copy

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"TimS" wrote in message
...
any advice appreciated. - how can i copy a hidden sheet to a new workbook?

All times are GMT +1. The time now is 06:07 PM.