| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way to put worksheets in alphabetical sequence?
I have a group of procedures costs that I am entering into excel as I work
them up. Each worksheet bears the name of the procedure. I would like to be able to alphabetize the worksheets. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Is there a way to put worksheets in alphabetical sequence?
Hi,
Right click any worksheet tab, view code and paste the code below in and run it Sub Sortem() For X = 1 To Worksheets.Count For y = X To Worksheets.Count If UCase(Sheets(y).Name) < UCase(Sheets(X).Name) Then Sheets(y).Move Befo=Sheets(X) End If Next Next End Sub Mike "CH" wrote: I have a group of procedures costs that I am entering into excel as I work them up. Each worksheet bears the name of the procedure. I would like to be able to alphabetize the worksheets. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to arrange worksheets in alphabetical order? | Excel Worksheet Functions | |||
| How to put worksheets in Alphabetical order? | Excel Discussion (Misc queries) | |||
| Worksheets alphabetical? | Excel Discussion (Misc queries) | |||
| How do I put worksheets in alphabetical order | New Users to Excel | |||
| How do I put worksheets in alphabetical order | Excel Worksheet Functions | |||
Linear Mode
