Steve,

You had 2 replies to this on 23rd. Did neither suit, and if not, what was
the problem?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Steve" <sailor4life61@hotmaildotcom wrote in message
...
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