Arraning Excel Sheet in a given series

Will it be possible to rearrange the sheets of a book in a given order.

It is possible, but we need more information on what order you'd like to put them in. And based what.

If the sheet name is "1, 2, 3, 4, 5, 6, 7, 8, 9, 10"

I want to rearrange in this order "1, 3, 5, 7, 9, 2, 4, 6, 8, 10"...

Note: Sheetname could be Alphanumeric also. i want to rearranged based order given by me.

Maybe for your example.

Please Login or Register  to view this content.

For this one your Array needs to be in reverse order of your arrangement.

In a normal excel Book, the sheets will in this order... " Sheet1, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6, Sheet7, Sheet8, Sheet9, Sheet10".

Now i want to rearrange them in a new order like this... "Sheet8, Sheet9, Sheet10, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6, Sheet1, Sheet7"

Something without any order... that is what i mainely required. That order will be defined by me...

This is working well.. Sheets are not arranged in the given order. can you explain me how to fill the inputbox exactly with my given example.

Now i want to rearrange them in a new order like this... "Sheet8, Sheet9, Sheet10, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6, Sheet1, Sheet7"

Enter like this,
Sheet8, Sheet9, Sheet10, Sheet2, Sheet3, Sheet4, Sheet5, Sheet6, Sheet1, Sheet7

i have given the same input within double codes. But still the sheets were remains in the same order as it was in original. Can pls check and do the needful in closing the issue. this is help me a lot.

Do not Give double cotes.