Sorting Sheets in Workbook
 

Hi,
I have a workbook which has around 450 sheets and unordered. All the sheets
are named using integer strings viz..1, 2, 5, 6, 11, 56 etc. New sheets will
be added at the end.
I want to order these sheets using Excel macro or VBA.
Could you please let me know how I could achieve this?

Requirement is
Current order of workbook sheets
1, 5, 3, 7, 10,.9,15, 20,22, 2 etc.

After running the macro, I need the sheets to be in the order
1,2,3,5,7,9,10,15,20,22 etc.

Thanks in Advance,
Mnj 78

Sorting Sheets in Workbook
 

Hi
see your other post

P.S.: please don't multipost

--
Regards
Frank Kabel
Frankfurt, Germany

"Mnj 78" schrieb im Newsbeitrag
...
Hi,
I have a workbook which has around 450 sheets and unordered. All the
sheets
are named using integer strings viz..1, 2, 5, 6, 11, 56 etc. New
sheets will
be added at the end.
I want to order these sheets using Excel macro or VBA.
Could you please let me know how I could achieve this?

Requirement is
Current order of workbook sheets
1, 5, 3, 7, 10,.9,15, 20,22, 2 etc.

After running the macro, I need the sheets to be in the order
1,2,3,5,7,9,10,15,20,22 etc.

Thanks in Advance,
Mnj 78