I'm using the code below to sort some data.


Range("B11:R35").Select
Selection.sort Key1:=Range("N11"), Order1:=xlDescending, Header:=xlGuess _
, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom, _
DataOption1:=xlSortNormal




Rather than having to change the range for the data i want to sort i would like to be able to find the lower limit. The beginning of the range will always be B11 and the end will always be somewhere in column "R"

I'm sure I've seen this done using an "end" argument

Note some of the columns in the range will be blank but none of the rows will be