Sorting Sheets in a Workbook
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
|