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
-
Muslim Pro
-
Animal Crossing: Pocket Camp
-
Tacticool - 5v5 shooter
-
Resident Evil 3: Raccoon City Demo
-
Minecraft: Education Edition
-
Ukulele Tabs & Chords
-
Amigurumi
-
HEALTHLYNKED COVID-19 Tracker
-
COVID Symptom Tracker
-
Zoom
-
Houseparty