any advice appreciated. - how can i copy a hidden sheet to a new workbook?
B Bob Phillips Apr 8, 2004 #2 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)
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)
