How to Short sheet name by two kinds of sheets names( alpabet then numeric )

[herukuncahyono]

Hi,
How to sort the sheet name from the alphabet and then numbers

Please Login or Register  to view this content.

Sheet names : 1,2,3,a,b,c
above code produces the sequence: ---> 1,2,3,a,b,c
Want to be sorted into--> a,b,c,1,2,3

Thanks in advance

[ragulduy]

Maybe do something like:

Please Login or Register  to view this content.

Might not work if your real data is very different to your example though.

[jindon]

Try

Please Login or Register  to view this content.

[herukuncahyono]

hi jindon,
Thanks for your code..its work...nice