Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I want to create a macro which would move a set of selected sheets from
one book to another. I know how to select the sheets and move them e.g.: Sheets(Array("List5", "List3")).Select Sheets("List3").Activate Sheets(Array("Sheet5", "Sheet3")).Move Befo=Workbooks ("Book3").Sheets(3) But what if the sheets are already selected before starting the macro. So I don't need the "Select" method and instead of Sheets(Array ("Sheet5"...).Move I'd need something like Sheets(<selected sheets).Move TIA, Primoz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving Data between sheets in the same workbook and moving data between Workbooks. | Excel Worksheet Functions | |||
Moving Mutli-Column Multiple-Selected Listbox items up or down | Excel Discussion (Misc queries) | |||
Moving Selected Fields to Summary Sheet | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
Moving selected data | Excel Worksheet Functions |