Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy before sheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy before sheet
Scott,
Try something like Worksheets("Sheet1").Copy befo=Worksheets("End") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Scott" wrote in message ... 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? Scott |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy before sheet
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy rows from one Data sheet to another sheet based on cell conte | Excel Discussion (Misc queries) | |||
Auto Copy/autofill Text from sheet to sheet if meets criteria | Excel Discussion (Misc queries) | |||
how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
'Copy to' Advance Filter depend only on sheet ID not start sheet | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) |