Sorting macro

[hitbid]

The problem here is I am poor at creating sorting macros, and use the recorder, and tried to implement a variable for the bottom row. This is an easy fix, right?

I am getting error for this, "doesn't support this property or method".
The first error is in Bold below.
B_Row is defined just fine, and equals 335 when I float the mouse over it.

    ActiveWorkbook.Worksheets("EQ").Sort.SortFields.Clear
    With ActiveWorkbook.Worksheets("EQ").Sort
[B]        .SortFields.Add2 Key:=Range("E1:E" & B_Row), _[/B]
[B]        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal[/B]
        .SortFields.Add2 Key:=Range("C1:C" & B_Row), _
        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        .SortFields.Add2 Key:=Range("A1:A" & B_Row), _
        SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
        .SetRange Range("A1:K" & B_Row)
        .Header = xlGuess
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With

 

[Fluff]

Try changing the Add2 to Add

 

[hitbid]

Son of.....

Yep, thanks again, always a reliable response from you. Appreciate it.

No clue why I had it like that.

 

[Fluff]

You're welcome & thanks for the feedback.
I think it's something that came in with 2016, but not sure what Add2 does.
I've just seen other members saying to change it.

 

[hitbid]

Makes sense. I created the macro at home on a newer version of excel, 2016, and tried to just drop it into the work computer.