View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Chip Pearson Chip Pearson is offline
external usenet poster
 
Posts: 7,247
Default sheets in alphabetical order


The code on that page has an option for starting the sort at the
second (or any subsequent) sheet, but for a one-time sort, it is
probably easier to sort them all.

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Wed, 17 Dec 2008 06:55:31 -0800, Gary''s Student
wrote:

First sort them all:

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

and then manually drag the desired first sheet to the left and the desired
last sheet to the left.