http://support.microsoft.com/kb/812386

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JStiehl" wrote in message
...
I need help with VBA code to sort tab names with numbers in order, but
leave
the ones with words as they are. Tab names with numbers should precede
the
tabs with words. I have searched and can only find codes to sort
alphanumerically. Thanks for your help.

Example of what order I would like my tabs in:

123890
456678
789123
Project1
Project2
Project3
Total
Findings