sort tabs by alphabetically order

**AaruJaan** · 07-11-2017, 03:15 PM

Hi,

I want to sort tabs by alphabetically order, I have big file with many tabs, tabs start from the Hp1 to H100, I need the macro vba to sort the three ways I have specified:

1) small to large e.g hp1, hp2, hp3
2) large to small e.g hp65, hp64, hp63
3) by colour of tab

Thanks in advance

Thank you

**YasserKhalil** · 07-11-2017, 03:26 PM

This code is to sort sheets from A to Z

Please Login or Register  to view this content.

If you want to sort from Z to A change > to < ..

**AaruJaan** · 07-11-2017, 03:34 PM

Hi Yasser,
If I need to sort from Z to A,what I do?

**YasserKhalil** · 07-11-2017, 03:37 PM

And this code for sorting by tabs color

Please Login or Register  to view this content.

**YasserKhalil** · 07-11-2017, 03:38 PM

Originally Posted by farhangul

Hi Yasser,
If I need to sort from Z to A,what I do?

Change that line

Please Login or Register  to view this content.

to be

Please Login or Register  to view this content.

sort tabs by alphabetically order

LinkBack

Thread Tools

Rate This Thread

Display

sort tabs by alphabetically order

Re: sort tabs by alphabetically order

Re: sort tabs by alphabetically order

Re: sort tabs by alphabetically order

Re: sort tabs by alphabetically order

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula to extract unique values from two excel tabs and sort alphabetically

[SOLVED] Order / sort range by number in bracket first then remainder alphabetically.

months sort alphabetically even though I selected custom order

Need to show worksheet tabs alphabetically

Need to show worksheet tabs alphabetically

sort alphabetically and numerically, then sort rows

Alphabetically order sheet tabs??

Can I sort Excel sheet tabs alphabetically?

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions