Macros to sort data with respect to the colum
Solved/Closed
Test
-
5 Feb 2010 à 00:39
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 Feb 2010 à 04:50
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 Feb 2010 à 04:50
Related:
- Macros to sort data with respect to the colum
- Excel online macros - Guide
- How to copy data from one excel sheet to another - Guide
- Tmobile data check - Guide
- How to sort bookmarks in chrome - Guide
- How to reinstall windows 10 without losing data - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
5 Feb 2010 à 04:50
5 Feb 2010 à 04:50
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
