Move has a before/after argument. If you specify a workbook using this
argument, then you can move your sheets to an existing workbook.

--
Regards,
Tom Ogilvy

"dororke" wrote in message
...
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/