| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I copy just the visible sheets?
I realise I can make the sheets I want to copy visible, then copy them as per
below (using variables for sheet names) Sheets(Array(CCRFsheet2, CCRFsheet3, CCRFsheet4a, CCRFsheet6, CCRFsheet7a, CCRFsheet7b, CCRFsheet8, CCRFsheet9)).Copy But is it possible to write a macro that will work out what sheets are visible and then only copy those sheets to another WorkBook? -- Trefor |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy and past to different sheets | Excel Discussion (Misc queries) | |||
| copy workbook sheets? | Setting up and Configuration of Excel | |||
| Copy formatted in several sheets of a workbook | Excel Worksheet Functions | |||
| Copy with link between sheets - all the formats dissapear?!? | Excel Discussion (Misc queries) | |||
| Copy & Paste Visible Cells with Formulas | Excel Worksheet Functions | |||
Threaded Mode
