It is VBA not a formula.

From Excel, Alt-F11 to get to the VBIDE. Menu InsertModule, and then copy
Chip's code.

Go back to Excel. Menu ToolsMacroMacros.., select the macro from the list
and click Run.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"piagax2" wrote in message
...
not sure where to put that formula given from c.pearson or how to go about
doing it

"piagax2" wrote:

I have an excel spreadsheet that I am doing and it has about 100 sheets
within the spreadsheet (tabs on botom) Is there a way to sort those
sheets?