Last Used Row (Last Used Column) in Excel with Formula (without VBA)
Getting the last row of a given column in Excel is easily done with a User-Defined Function in VBA: Function LastRow(wsName As String, Optional columnToCheck As Long = 1) As Long Dim ws As Worksheet Set ws = Worksheets(wsName) LastRow …
Last Used Row (Last Used Column) in Excel with Formula (without VBA) Read more »