Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Determines the last row and column in the worksheet
Sub rowCol()
     Set rngLast = Range("A1").SpecialCells(xlCellTypeLastCell)
     lLastRow = rngLast.Row
     lLastCol = rngLast.Column
End Sub