Sorting Using Code

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

I have a data table A5:L3776 - Row 5 is header info
I need to enter code to sort this range
Primary Sort on B Column
Secondary Sort on G Column
The Macro recorder is screwing things up.
Can someone get me through this?
TIA,
 
Range("A5:L3776").Sort Key1:=Range("B5"), _
Order1:=xlAscending, Key2:=Range("G5"), _
Order2:=xlAscending, Header:=xlYes, _
OrderCustom:=1, MatchCase:=False, _
Orientation:=xlTopToBottom
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Worksheet sorting code/technique advise 55
Problem sorting a range of columns using VBA 1
Sorting columns horizontally 2
Modify Sort Routine to inlcude All Data 2
Sorting a named range using first three columns 5
Modify Claus code "Sub Array_Var_Column_Sort()" 27
2 level sorting 1
Sort on 3 columns when number of rows vary daily 1

Back
Top