Getting the correct Syntax for Range in Sorting

Hi all,

I'm trying to get the correct syntax for identifying the range in a variable sized table on sorting. The line using a fixed range reference - Range("E2:E296") - works but doesn't cater for the changing table size. I've tried syntax in the line above to correct this but it's giving me an error. Can anyone advise what the correct syntax is please,

thanks, Neil

Sub a1()
   
    
    With ActiveWorkbook.Worksheets("Analysis Sheet").Sort      
        .SortFields.Clear
        .SortFields.Add Key:=Range("d2", ActiveCell.End(xlDown)).Address,
SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal            
        .SortFields.Add Key:=Range("E2:E296"), SortOn:=xlSortOnValues,                         Order:=xlAscending, DataOption:=xlSortNormal         
        .SetRange DataRange            
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply                                      
    End With
    
  
End Sub

Try:

Range("E2:E" & Range("E" & Rows.Count).End(xlDown).Row)

Regards

Well, once upon a time, I was asking exactly the same questions. It just takes time and practice. Monitoring the questions and answers in the forum is a great way to learn ... and asking questions.

Regards