View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jo Jo is offline
external usenet poster
 
Posts: 113
Default Move multiple worksheets to a new workbook

Good day,
I am using a macro to create new worksheets in a wkb and consequently all
these "new" worksheets move to a new workbook.
Tried to help me out with a macro recorder:
Sheets(Array("Sheet1 (2)", "Sheet1 (3)")).Move

the line works just exact the way I need, but I'm not able to rephrase it
with variable names of worksheets (in my macro I need to move all worksheets
with item number 5).
Is there any easy solution for this?
Thanks in advance