Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I'm new in macro programming and it is not sorting. Can someone help me?
This is the code: SortData: 'Sort Data worksheet Dim myrange As Range Dim LastRow As Variant Worksheets("Data").Select 'Establish range for sort 'Get the last row of worksheet Data LastRow = ActiveSheet.Cells(Rows.Count, "B").End(xlUp).Row Set myrange = Range("B10:S" & LastRow) 'Sorts ascending by Section ID ("H10") With myrange .Sort Key1:=Range("H10"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _ DataOption1:=xlSortNormal End With |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sorting Values Without Sorting Formulas | Excel Discussion (Misc queries) | |||
Automatic sorting (giving max and min) based on custom sorting lis | Excel Worksheet Functions | |||
Sorting VLookup vs Sorting SumProduct | Excel Discussion (Misc queries) | |||
Sorting: Sorting by the First Character | Excel Discussion (Misc queries) | |||
Sorting | Excel Discussion (Misc queries) |