| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move a worksheet position
I have a macro which pastes a worksheet into a 15 sheet workbook. How can I
get the new sheet into the desired poisition (2nd to last) programmatically? Thanks in advance |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move a worksheet position
with workbooks("book2.xls")
activesheet.copy _ befo=.sheets(.sheets.count) end with "Jimbob" wrote: I have a macro which pastes a worksheet into a 15 sheet workbook. How can I get the new sheet into the desired poisition (2nd to last) programmatically? Thanks in advance |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move a worksheet position
Hi
Look at this: Sheets(1).Move Befo=Sheets(Sheets.Count) Sheets("Sheet1").Copy Befo=Sheets(Sheets.Count) Regards, Per "Jimbob" skrev i meddelelsen ... I have a macro which pastes a worksheet into a 15 sheet workbook. How can I get the new sheet into the desired poisition (2nd to last) programmatically? Thanks in advance |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Move a worksheet position
Terrific.
Thanks to you both. "Per Jessen" wrote: Hi Look at this: Sheets(1).Move Befo=Sheets(Sheets.Count) Sheets("Sheet1").Copy Befo=Sheets(Sheets.Count) Regards, Per "Jimbob" skrev i meddelelsen ... I have a macro which pastes a worksheet into a 15 sheet workbook. How can I get the new sheet into the desired poisition (2nd to last) programmatically? Thanks in advance |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Short cut to move back to last position | Excel Discussion (Misc queries) | |||
| Move the position of spreadsheet on the screen | Excel Programming | |||
| Change position of move or copy worksheet option in Excel | Excel Discussion (Misc queries) | |||
| Macro to move first name to last position in cell | Excel Programming | |||
| Move Cell to Top/Left Position on Screen | Excel Programming | |||
Linear Mode
