Finding Last Used Row or Column In Excel Sheet

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

Code:

---

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

---