Is there a way to programatically resort the sheets in a workbook
 

I have like 100 sheets in a workbook and I wanted to sort them
alphabetically. Is there an easy way to do this without manually moving them.

Thanks in advance,
John

Is there a way to programatically resort the sheets in a workbook
 

Here you go, John:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=72
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"John" wrote in message
...
I have like 100 sheets in a workbook and I wanted to sort them
alphabetically. Is there an easy way to do this without manually moving
them.

Thanks in advance,
John

Is there a way to programatically resort the sheets in a workbook
 

Take a look at

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


In article ,
"John" wrote:

I have like 100 sheets in a workbook and I wanted to sort them
alphabetically. Is there an easy way to do this without manually moving them.

Thanks in advance,
John

Is there a way to programatically resort the sheets in a workbook
 

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

--
HTH

Bob Phillips

"John" wrote in message
...
I have like 100 sheets in a workbook and I wanted to sort them
alphabetically. Is there an easy way to do this without manually moving
them.

Thanks in advance,
John