Related:
- Macros to sort data with respect to the colum
- Macro to sort data with respect to the column - How-To - Excel
- Excel macro that inserts data with a button - How-To - Excel
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- Macro to pull data from another worksheet based on criteria - How-To - Excel
- How to sort data on multiple worksheets at once - How-To - Excel
1 reply
rizvisa1
- Posts
- 4476
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- August 2, 2020
you need to start from sort from row 2 and tell that there is a header
Selection.Sort _
Key1:=Range("A2"), Order1:=xlAscending, _
Header:=xlYes, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Selection.Sort _
Key1:=Range("A2"), Order1:=xlAscending, _
Header:=xlYes, OrderCustom:=1, _
MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal
Subscribe To Our Newsletter!
