Move array of worksheets into another workbook

[jaryszek]

Hi Guys,

i want to select 3 dynamic worksheets names into another workbook:

So something like:

Please Login or Register  to view this content.

but in "Customer" and "Development" i can have dynamic changed variable.
So worksheets can have different names.

How can i pass worksheet variables into this method?
I didnt found solution in web...

Please help,
Jacek

[jindon]

If you know sheet index of the worksheets then

Please Login or Register  to view this content.

will move left 3 worksheets.

Or simply use array variable like

Please Login or Register  to view this content.

[Kaper]

You can use standard array of strings to do that.
And any array element can be directly filled with sheet-to-be-moved name, like (just illustrative, simplest case):

Please Login or Register  to view this content.

but of course you can first

Please Login or Register  to view this content.

and then dynamically grow the array

Please Login or Register  to view this content.

and finally, once the whole arr is ready move all "collectred" sheets:

Please Login or Register  to view this content.

[jaryszek]

Thank you Guys,

very helpful.

Jacek