Find Last Used Row In Column

[Rasm]

This finds last row in column "B"

With ActiveSheet
        LastRowCol = .Range("B" & .Rows.Count).End(xlUp).Row
End With