how to define variable row count in macros?

[ansvk1]

Hi there,
I would to ask for a little help with learning how to change my row values to a variable while i was trying to customise/write this VBA code (from recorded macro) to suit my needs.

here is the

Sub Macro2()


    Range("A1").Select
    Range(Selection, Selection.End(xlToRight)).Select
    Range(Selection, Selection.End(xlDown)).Select
    ActiveWorkbook.Worksheets("Summary").AutoFilter.Sort.SortFields.Clear
    'now sorting for Levles from 4 to 1
    ActiveWorkbook.Worksheets("Summary").AutoFilter.Sort.SortFields.Add Key:= _
        Range("N2:N189" & xlDown??), SortOn:=xlSortOnValues, Order:=xlDescending, DataOption _
        :=xlSortNormal
    'now sorting for Responsible Parties
    ActiveWorkbook.Worksheets("Summary").AutoFilter.Sort.SortFields.Add Key:= _
        Range("T2:T189" & xlDown??), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption _
        :=xlSortNormal
    With ActiveWorkbook.Worksheets("Summary").AutoFilter.Sort
        .Header = xlYes
        .MatchCase = False
        .Orientation = xlTopToBottom
        .SortMethod = xlPinYin
        .Apply
    End With
    Range("A1").Select
End Sub

i am trying to change the selection part form N2:N189 to N2:NxlDown (so that it selcts however many row are present later on). How can i do that?
Thanks in advance!

 

[ansvk1]

Yep, i tried to run the code by skipping those two lines and it seemed to have sorted everything fine. but i couldn't tell for sure as i had about 200 rows data.

So, i was just wondering if we has to have the selection made before using the custome sorting. Thanks for the answers guys!