Get the actual used range in a spreadsheet

Get the actual used range in a spreadsheet

31 May 2014

Excel keeps track of the last cell you used during your current session, and uses it to determine the used range of a sheet. The last cell is the one you get to when you press Ctrl+End.

This article describes some VBA functions to get the:

  • First used cell.
  • Last used cell.
  • Actual used range.