Worksheet name in order

[Michael168]

Can someone tell me how to sort/arrange worksheets name in a order but
not by dragging sheet after sheet in ws tabs column.

It is possible to do in VBA.

Thank you.

 

[Chip Pearson]

Michael,

See http://www.cpearson.com/excel/sortws.htm for example VBA code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)