Related:
- Macros to sort data with respect to the colum
- Macro to sort data with respect to the column - How-To - Excel
- Macro to copy data from one sheet to another based on criteria ✓ - Forum - Excel
- Macro to copy data from another workbook - How-To - Excel
- Macros: Copy Invoice Details From One Sheet to Another ✓ - Forum - Excel
- How to copy data from one sheet to multiple sheets using IF - Forum - 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
