Get the Actual Used Range in a Spreadsheet

Actual Used Range

In one of my posts, I wrote about the UsedRange property of the Worksheet object. I use it in almost all of my spreadsheet applications. 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.

Continue reading “Get the Actual Used Range in a Spreadsheet”