Sorting SOME Worksheets Alphabetically

[wjsok85]

Hi,

I have been looking at Macros that sort worksheets alphabetically, but there are sheets within my workbook that I want to leave static.

I have two sheets, names 'Start' and 'Spacer', what I would ideally like to have is a marco that will alphabetically arrange the sheets between these sheets, leaving the others where they are and obviously leaving 'Start' and 'Spacer' at the front and end of the range respectivly!

Any Ideas?

Thanks in advance!

Wil

[DonkeyOte]

Will be better methods for sure...

Please Login or Register  to view this content.

[royUK]

Does this work

Please Login or Register  to view this content.

[wjsok85]

Hi,

Thanks for both the replys - have it sorted

Thanks again

[furiousfox]

These are great solutions
Worked for me too!!

Thanks

[shg]

A variation:

Please Login or Register  to view this content.