Alter 12)

Resets the Used Range for the Current Tab

Resets the “Used Range” so you can quickly see the True bottom right corner of a worksheet.

The “Used Range” of a worksheet is the part that Excel thinks is being used by containing any of the following:
Content, Formatting, Notes, Outlines, or Comments

When you remove rows or columns or otherwise remove cells Excel does not automatically define the new range.
The new “Used Range” can only be defined by Saving the workbook OR by using this function.

Knowing the used range is important because users sometimes inadvertently enter data at the far right or extreme bottom of the worksheet.

The used range can be seen by depressing CTRL-END.


Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc