Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,069
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 221
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,624
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,120
Default 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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting sheet.xlt for a workbook programatically trooper665 Excel Programming 2 June 17th 05 09:19 PM
programatically retrieve selected rows from excel workbook talktobatchu Excel Programming 0 June 1st 05 10:15 PM
Programatically saving workbook (or worksheet) without the code Hugh Excel Programming 4 October 22nd 04 12:03 AM
Excel crashing when (programatically) adding past the 360th worksheet to a workbook Scott Lyon Excel Programming 2 August 14th 03 12:34 PM
Copy Worksheet to another workbook, programatically? plh[_2_] Excel Programming 5 August 13th 03 08:12 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"