Finding Last Used Row or Column In Excel Sheet

[Rasm]

This is for the entire sheet - so ALL rows - ALL columns



With ActiveSheet.UsedRange
LastRow = .Rows(.Rows.Count).Row
ColLast = .Columns(.Columns.Count).Column
End With