Sort Excel Worksheets Based on Second Letter In Name

[JimHol]

Is it possible to have a macro that will sort all of the worksheets in my workbook by the second character in the sheet name only is the first character is a number. If the first character is not a number it would sort using the first character.

Thanks,
Jim

 

[BigC]

Check out the list of 585 Excel articles on this site (goto home page and then scroll down to the very bottom to the General section to find the page link http://www.mrexcel.com/articles.shtml
In the VBA section there is a link (http://www.cpearson.com/excel/sortws.aspx)
to an article by Chip Pearson about sorting worksheets by name, etc. from which I expect you can adapt the code to suit your situation.

You may need additional code to create and populate an array with "trimmed" sheet names to use as the basis for the sorting. These will be derived by using an If x Then y test to identify which sheet names have numbers as 1st characters that need to be dropped using a string method, and which don't)