View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mnj 78 Mnj 78 is offline
external usenet poster
 
Posts: 1
Default 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