Sort tabs

[Guest]

Is there a way to sort tabs in the worksheet? I've been manually dragging the
tabs to put them in the alphabetical order, but if someone can advise a way,
that would be great.
Thanks

 

[Jim Rech]

Chip Pearson has a macro for sorting worksheets.

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

--
Jim
| Is there a way to sort tabs in the worksheet? I've been manually dragging
the
| tabs to put them in the alphabetical order, but if someone can advise a
way,
| that would be great.
| Thanks

 

[NickG]

this VBA code should help you achieve what you want.

 

[NickG]

this VBA code should help you achieve what you want.

 

[Chip Pearson]

If you're going to take verbatim code from my site, I would
appreciate a reference to the page.
www.cpearson.com/excel/sortws.htm


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"NickG" <[email protected]>
wrote in message