Macros to sort data with respect to the colum
Solved/Closed
Test
-
Feb 5, 2010 at 12:39 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 5, 2010 at 04:50 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 5, 2010 at 04:50 AM
Related:
- Macros to sort data with respect to the colum
- Transfer data from one excel worksheet to another automatically - Guide
- How to sort bookmarks in chrome - Guide
- Spotify sort by genre - Guide
- Macros in excel download - Download - Spreadsheets
- Digital data transmission - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 5, 2010 at 04:50 AM
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