Macros to sort data with respect to the colum
Solved/Closed
Test
-
Feb 5, 2010 at 12:39 AM
rizvisa1
rizvisa1
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
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
- 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
- Copy data from one sheet to another based on condition using VBA - Forum - Excel
1 reply
rizvisa1
Feb 5, 2010 at 04:50 AM
- Posts
- 4479
- Registration date
- Thursday January 28, 2010
- Status
- Contributor
- Last seen
- May 5, 2022
Feb 5, 2010 at 04:50 AM
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