Copy before sheet

S

Scott

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
 
C

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


Scott said:
Hello
I am trying to modify an existing code that uses .copy
Click to expand...
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?
 
S

Scott

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!
 
Top