Macro for sorting worksheets

Posted by Tim on May 04, 2000 6:20 PM

I am having trouble figuring out how to sort some worksheets.

I have a workbook that contains 5 worksheets:

Worksheet A, Worksheet B, Worksheet C, Worksheet D, Worksheet E.

Then I have a macro that creates a whole bunch (random ammount) of worksheets based on information in B.

What I need to do is sort the worksheets so that the order is like so: A, B, C, D, All New worksheets in alphabetical order, E.

Any ideas?

Posted by Celia on May 04, 2000 7:49 PM

Tim

I think you will find what you need at:-

http://www.cpearson.com/excel/sortws.htm

Celia

Posted by Tim on May 04, 2000 8:39 PM

Thank You Celia

Thank you, And very cool site.