If your numbers are constant values you can simply extend your code as proposed by @taller, but you can still rely on the Range.Find
procedure:
Sub LastNumber()
Dim LastRow As Long
LastRow = ActiveSheet.Range("A6:A167").SpecialCells(xlCellTypeConstants, xlNumbers) _
.Find(What:="*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
MsgBox LastRow
End Sub