Copy before sheet

[Guest]

Hell
I am trying to modify an existing code that uses .copy after=("Start"). I want the copy to be before "End". I have changed to .copy before=("End"). But it is copying after END. What am I doing wrong
Scott

 

[Chip Pearson]

Scott,

Try something like

Worksheets("Sheet1").Copy before:=Worksheets("End")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

Hello
I am trying to modify an existing code that uses .copy

after=("Start"). I want the copy to be before "End". I have
changed to .copy before=("End"). But it is copying after END.
What am I doing wrong?

 

[Guest]

Thanks for the reply
I found my problem, I think. END Is hidden and it copies after END. If I unhide END then it copies correctly. Is there a way around unhiding the sheet
Thanks!