Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabatizing my worksheets
What code might I use to sort all the worksheets except the master summary
sheet into alphabetic order? (The master summary sheet's tab name is unique and I want it to always be the first tab in the workbook.) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabatizing my worksheets
You could use a macro...
Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) ======= And I'd just let the macro sort the mastersheet, too. Then after the sort, you can add code to move it to the leftmost position. Sheets("summary").Move befo=Sheets(1) (change the name as required.) John wrote: What code might I use to sort all the worksheets except the master summary sheet into alphabetic order? (The master summary sheet's tab name is unique and I want it to always be the first tab in the workbook.) -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabatizing my worksheets
This is a very primitive one. But try it.
Sub sortsheetname() Dim n As Long, i As Long For n = Worksheets.Count To 1 Step -1 For i = 2 To n - 1 If Worksheets(i).Name Worksheets(i + 1).Name Then Worksheets(i).Move after:=Worksheets(i + 1) End If Next Next End Sub Keiji John wrote: What code might I use to sort all the worksheets except the master summary sheet into alphabetic order? (The master summary sheet's tab name is unique and I want it to always be the first tab in the workbook.) |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Alphabatizing my worksheets
This was a lot of help. Thx for all the additional links!
I appreciate your help, -John "Dave Peterson" wrote: You could use a macro... Chip Pearson's: http://www.cpearson.com/excel/sortws.htm David McRitchie's: http://www.mvps.org/dmcritchie/excel...#sortallsheets If you're new to macros: Debra Dalgleish has some notes how to implement macros he http://www.contextures.com/xlvba01.html David McRitchie has an intro to macros: http://www.mvps.org/dmcritchie/excel/getstarted.htm Ron de Bruin's intro to macros: http://www.rondebruin.nl/code.htm (General, Regular and Standard modules all describe the same thing.) ======= And I'd just let the macro sort the mastersheet, too. Then after the sort, you can add code to move it to the leftmost position. Sheets("summary").Move befo=Sheets(1) (change the name as required.) John wrote: What code might I use to sort all the worksheets except the master summary sheet into alphabetic order? (The master summary sheet's tab name is unique and I want it to always be the first tab in the workbook.) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare Rows on different Worksheets and Output Difference's to other Worksheets. | Excel Programming | |||
How use info in Excel shared worksheets to create new worksheets | Excel Worksheet Functions | |||
VBA / Macro for creating new worksheets and new columns from existing worksheets | Excel Programming | |||
Alphabatizing Combo Boxes | Excel Programming | |||
Need code to protect worksheets - amount of worksheets varies | Excel Programming |