Sort Worksheet Tabs

B

BSII

Does anyone know of a VBA command or program string to sort the worksheet tab
order? I have a program that divides up data into 10+ tabs and renames the
worksheets automatically. I'd then like to sort them alphabetically.

Thank you for any help you can offer.
 
J

Jim Cone

- or-
The free Excel add-in XL Extras will do that;
right-click a sheet tab and select sort. Download from...
http://www.realezsites.com/bus/primitivesoftware
--
Jim Cone
San Francisco, USA


"BSII" <[email protected]>
wrote in message
Does anyone know of a VBA command or program string to sort the worksheet tab
order? I have a program that divides up data into 10+ tabs and renames the
worksheets automatically. I'd then like to sort them alphabetically.

Thank you for any help you can offer.
 

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

Consolidation Table from Different Excel Tabs with Different Format 1
[Q] How to sort tabs in order of CodeName 2
Sort tabs numerically 9
Sort partially hidden data 1
Help Needed ! 0
Addition to current VBA - Keep text format 1
Find Specific Rows in Range and Create New Tab 18
Multiple tabs in 1 worksheet 3

Top