Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort worksheets in alphabetical order (descending or ascending)?
Hi Am using Excel 2003. I am using a workbook with various worksheets named differently. For example, I have the following worksheets in the "tabs" area: Sheet Kiwi Sheet Apple Sheet Orange Sheet Banana How can I sort them, so that they appear to me (from left to right) like: Sheet Apple Sheet Banana Sheet Kiwi Sheet Orange Thanks a lot. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort worksheets in alphabetical order (descending or ascend
You could try
Sub liminal_advertisment() Dim I As Integer, J As Integer For I = 1 To Sheets.Count - 1 For J = I + 1 To Sheets.Count If UCase(Sheets(I).Name) UCase(Sheets(J).Name) Then Sheets(J).Move Befo=Sheets(I) End If Next J Next I End Sub Mike " wrote: Hi Am using Excel 2003. I am using a workbook with various worksheets named differently. For example, I have the following worksheets in the "tabs" area: Sheet Kiwi Sheet Apple Sheet Orange Sheet Banana How can I sort them, so that they appear to me (from left to right) like: Sheet Apple Sheet Banana Sheet Kiwi Sheet Orange Thanks a lot. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to sort worksheets in alphabetical order (descending or ascending)?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i change the order(ascending, descending) in a column? | Excel Discussion (Misc queries) | |||
How do I arrange/sort worksheets in ascending order? | Excel Discussion (Misc queries) | |||
Excel worksheets needs to sort ascending or descending order. | Excel Worksheet Functions | |||
Formatting cells in Excel with Ascending/Descending order | Excel Discussion (Misc queries) | |||
Sort other than by alphabetical ascending/ descending | Excel Discussion (Misc queries) |