Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default copy a hidden sheet

any advice appreciated. - how can i copy a hidden sheet to a new workbook?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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?



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy hidden sheet data Atiq Excel Discussion (Misc queries) 2 January 27th 10 08:41 PM
after creating a copy of a sheet, several rows missing (not hidden dcdus Excel Discussion (Misc queries) 11 September 15th 09 10:13 PM
Excel: copy and paste only shown not hidden cells into new sheet MU Excel Discussion (Misc queries) 1 February 6th 06 10:31 PM
How Can I copy a sheet that has hidden rows without copying the h. ibrahim Excel Worksheet Functions 1 January 13th 05 01:25 AM
copy to hidden sheet bob Excel Programming 2 July 19th 03 02:33 PM


All times are GMT +1. The time now is 03:18 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"