| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy before hidden sheet
I am trying to insert a copied sheet before a hidden sheet, as it is now the
copy goes after the hidden sheet. Is there a modification to .copy before to accomplish this or is unhide, copy, then re-hide the way to do it? Sheets("Sheet2").Select ActiveWindow.SelectedSheets.Visible = False .Copy Befo=Worksheets("Sheet2") Sheets("Sheet2").Visible = True Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy hidden sheet data | Excel Discussion (Misc queries) | |||
| after creating a copy of a sheet, several rows missing (not hidden | Excel Discussion (Misc queries) | |||
| How Can I copy a sheet that has hidden rows without copying the h. | Excel Worksheet Functions | |||
| copy a hidden sheet | Excel Programming | |||
| copy to hidden sheet | Excel Programming | |||
Threaded Mode
