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?
|