LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Move sorted data from one worksheet to multiple worksheets? Mark Excel Worksheet Functions 1 October 4th 07 09:32 AM
Keyboard shortcuts to move between worksheets within a workbook Waj Excel Worksheet Functions 2 March 20th 07 08:24 PM
Move WorkSheets Within Same WorkBook!! James Cooper Excel Programming 3 June 28th 06 05:02 AM
Move worksheets to a new workbook mrdata[_6_] Excel Programming 9 March 5th 06 09:30 PM
Open & process multiple worksheets then move them to different folder. Prasad Vanka Excel Programming 1 May 18th 04 03:26 PM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"