Select non-empty cell range with VBA

Sub myTest()
   Dim lr As Long
    lr = Cells(Rows.Count, 3).End(xlUp).Row
    Range("c22:e" & lr).Select
End Sub

this above code do what your looking for