Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
i paste this code to code sheet but i dont know how can i sort my data after
that and what is this code Private Sub Worksheet_Change(ByVal Target As Range) Const WS_RANGE As String = "A:C" '<== change to suit On Error GoTo ws_exit Application.EnableEvents = False If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then Me.Cells.Sort key1:=Me.Range("A1"), order1:=xlAscending, _ key2:=Me.Range("B1"), order2:=xlAscending, _ heder:=xlYes End If ws_exit: Application.EnableEvents = True End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Data sorting automatically? | Excel Worksheet Functions | |||
Sorting automatically by columns | Excel Discussion (Misc queries) | |||
Sorting Data Automatically | Excel Worksheet Functions | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
sorting automatically | Excel Worksheet Functions |