Hi All,
I'm trying to write a macro to sort the sheets in a workbook. Currently I
have nearly 450 sheets which are not unordered. Could you please let me know
how I could achieve this.

Ex:
Currently the sheets are in the order 1, 5, 3, 7, 9, 20, 17, 21, 24, 22 etc.

I need that to be ordered as 1, 3, 5, 7, 9, 17, 20, 21, 22, 24 etc.

Thanks in Advance,
Mnj_78

Hi
see:
http://www.cpearson.com/excel/sortws.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Mnj 78" <Mnj schrieb im Newsbeitrag
...
Hi All,
I'm trying to write a macro to sort the sheets in a workbook.
Currently I
have nearly 450 sheets which are not unordered. Could you please let
me know
how I could achieve this.

Ex:
Currently the sheets are in the order 1, 5, 3, 7, 9, 20, 17, 21, 24,
22 etc.

I need that to be ordered as 1, 3, 5, 7, 9, 17, 20, 21, 22, 24 etc.

Thanks in Advance,
Mnj_78

Thanks for your help Frank.

And sorry for the multiple posts, every time I posted, I was getting a error
message that it was not posted correctly but internally the post was
submitted. Sorry for the inconvenience.

"Frank Kabel" wrote:

Hi
see:
http://www.cpearson.com/excel/sortws.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Mnj 78" <Mnj schrieb im Newsbeitrag
...
Hi All,
I'm trying to write a macro to sort the sheets in a workbook.
Currently I
have nearly 450 sheets which are not unordered. Could you please let
me know
how I could achieve this.

Ex:
Currently the sheets are in the order 1, 5, 3, 7, 9, 20, 17, 21, 24,
22 etc.

I need that to be ordered as 1, 3, 5, 7, 9, 17, 20, 21, 22, 24 etc.

Thanks in Advance,
Mnj_78