Sorting Sheets in a Workbook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

WCG Stats Sunday 06 November 2022 2
WCG Stats Thursday 10 November 2022 3
WCG Stats Tuesday 25 January 2022 1
WCG Stats Sunday 16 April 2023 2
WCG Stats Monday 14 February 2022 1
Sorting Sheets in a workbook 1
WCG Stats Tuesday 05 September 2023 3
WCG Stats Wednesday 12 January 2022 1

Back
Top