| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move a sheet to last sheet of wkbk
Hi All,
I am trying to move sheets from seperate files having 1 to 10 sheet in them to an established workbook. I want the sheets being moved to be added at the end of the destination workbook's sheets. Thought this would be quick and easy... ActiveWindow.ScrollWorkbookTabs Position:=xlLast Sheets.Select Sheets.Move After:=Workbooks("X.xls").Sheets() As always, any and all help appreciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying cell info from one sheet to another in the same wkbk | Excel Discussion (Misc queries) | |||
| move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
| Large wkbk won't recalc after moving sheet | Excel Discussion (Misc queries) | |||
| How do I replicate an area of a SS onto another sheet in same wkbk | Excel Discussion (Misc queries) | |||
| Copy paste WkBk/sheet 1 to multiple wkbks/sheets | Excel Programming | |||
Threaded Mode
