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.