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
|