3. VBA Tips - Reset the Used Range
An annoying feature of Excel is not resetting the the used range. What is the used range ? - well, it's meant to be a square around all populated cells.
- How can you select the Used Range for this example ?
Step1: Press CTRL + END - This will select the last populated cell
Step2: - Now press CTRL + SHIFT + HOME
... all your data is now selected. Now, here's the annoying thing. Suppose we delete the last 4 rows, and press CTRL + END again. - the last cell that was populated (but isn't now) is selected.
To reset the used range, we need to resort to using VBA.
If this code is in the worksheet's macro module, and is run, pressing CTRL + END will now go to the correct cell.
Training Video on how to reset the used range: