vba to sort multiple sheet tabs in a workbook

**JEAN1972** · 08-01-2016, 10:26 AM

Hi All

I have a workbook with multiple sheets .

Looking for fast vba code to sort sheet names alphabetically.

Also note some sheets are alpha numeric that is 01_15_ Sodium Peroxide Analysis

Thanks

**YasserKhalil** · 08-01-2016, 10:56 AM

Try this code

Please Login or Register  to view this content.

**Winon** · 08-01-2016, 10:58 AM

Hi JEAN1972,

Try this Code I saw on Mr. Excel some time ago.)

Please Login or Register  to view this content.

Regards.

**YasserKhalil** · 08-01-2016, 02:23 PM

Another code (I think for Mr. Jbeaucaire)

Please Login or Register  to view this content.

**nilem** · 08-01-2016, 03:35 PM

or maybe so

Please Login or Register  to view this content.

**YasserKhalil** · 08-01-2016, 04:03 PM

Thanks Mr. Nilem for the code
and may be

Please Login or Register  to view this content.

**Leith Ross** · 08-02-2016, 12:02 AM

Hello JEAN1972,

Just for fun. Here is another macro that will sort the worksheets either in ascending (a to z) or descending (z to a) order. This code is a little longer but uses a modified bubble sort which is twice as fast as a normal bubble sort. Doesn't mean much when sorting worksheets but is important when using it to sort lists.

Please Login or Register  to view this content.

**jindon** · 08-02-2016, 12:14 AM

Originally Posted by JEAN1972

Also note some sheets are alpha numeric that is 01_15_ Sodium Peroxide Analysis

What the other sheet names look like and how do you want sort them?

**JEAN1972** · 08-02-2016, 09:52 AM

Originally Posted by jindon

What the other sheet names look like and how do you want sort them?

Hi Jindon

Some examples numeric ones first AND alphabetical last like 01_15__sodium peroxide ,beoh_10a27,alphabetical,reports 2015_a_01IE.

**jindon** · 08-02-2016, 12:35 PM

Originally Posted by JEAN1972

Hi Jindon

Some examples numeric ones first AND alphabetical last like 01_15__sodium peroxide ,beoh_10a27,alphabetical,reports 2015_a_01IE.

See if this is how you wanted.

Please Login or Register  to view this content.

**JEAN1972** · 08-03-2016, 10:15 AM

Originally Posted by Winon

Hi JEAN1972,

Try this Code I saw on Mr. Excel some time ago.)

Please Login or Register  to view this content.

Regards.

Hi Winon

Getting compile error: next without for

Could you look in

**YasserKhalil** · 08-06-2016, 01:48 AM

Try

Please Login or Register  to view this content.

vba to sort multiple sheet tabs in a workbook

LinkBack

Thread Tools

Rate This Thread

Display

vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Re: vba to sort multiple sheet tabs in a workbook

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs

[SOLVED] Sort workbook Tabs only

How do I pull info from multiple sheet tabs to a log sheet tab in the same workbook

[SOLVED] Extract data from a workbook with multiple tabs, into a workbook with corresponding tabs

[SOLVED] Is it possible to sort the tabs in a workbook?

Can you sort sheet tabs in a workbook

[SOLVED] selecting multiple sheet tabs and open another workbook

Bookmarks

Bookmarks

Posting Permissions