Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving multiple worksheets to new workbook in VBA
Hi,
I have an existing workbook called wb1 containing 3 worksheets; ws1 - 3. I currently use a macro which extracts a subset of rows from ws1-3 and creates a new worksheet for each. Each worksheet is moved to a new workbook using Worksheet.Move but this creates a new workbook each time which is not desirable. Is there a way to create new sheets and move them to the same workbook? --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combine worksheets in multiple workbook in one workbook with a macro | Excel Discussion (Misc queries) | |||
Moving multiple worksheets as separate files | Excel Discussion (Misc queries) | |||
Moving worksheets to new workbook | New Users to Excel | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) | |||
Combine multiple workbooks into 1 workbook w/ multiple worksheets | Excel Discussion (Misc queries) |