Select range First Row to Last Row

[sh1pley]

FirstRow = Range("L1").End(xlDown).Row
FinalRow = Range("L65536").End(xlUp).Row

The range I want select in this case is from B14 to L80. However I do not know how to include "First Row" into the VBA code?

Range("B14:L" & FinalRow).Select

 

[VoG]

Perhaps

Range("B" & FirstRow & ":L" & FinalRow).Select

But why do you need to Select the range to work with it?

 

[sh1pley]

I was intending to select the range then sort it

 

[VoG]

Something like:

Range("B" & FirstRow & ":L" & FinalRow).Sort Key1:=Range("B" & FirstRow), Order1:=xlAscending, Key2:=Range("C" & FirstRow _
        ), Order2:=xlAscending, Key3:=Range("D" & FirstRow), Order3:=xlAscending, Header _
        :=xlGuess, OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom

will sort without selecting.