Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatically alphabetize excel worksheet
Where do I enter a string in the "worksheet code" to automatically
alphabetize my worksheet by the names in the A column. I have the string, I just don't know how to access the worksheet code??? Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Columns("A:A")) Is Nothing Then Else Application.EnableEvents = False Columns("A:A").Select Selection.Sort Key1:=Range("A1"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal Application.EnableEvents = True End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
alphabetize - automatically | Excel Worksheet Functions | |||
Is there a way to have a excel automatically alphabetize a sheet? | Excel Discussion (Misc queries) | |||
need to program my lists to automatically alphabetize when new ent | Excel Worksheet Functions | |||
How do I automatically alphabetize multiple worksheets in a singl. | Excel Discussion (Misc queries) | |||
how do I alphabetize items automatically in excel | Excel Worksheet Functions |