If you name a range of cells in Excel, you can use that name in a formula, or as the source for a data validation list, or as the data source for a pivot table.
You can also select the range, and use it to jump to specific cells when entering data, as in the Grades range, in the report card shown below.
Clear Cells in a Named Range
Another good use for a named range is to quickly clear a group of cells. For example, in this order form, information is entered in the green cells.
Name those cells, and you can quickly clear them before starting the next order.
- Select all the green cells, and name the range DataEntry.
- Click the arrow at the right of the Name Box, and click on DataEntry.
- With all the data entry cells selected, press the Delete key, to clear the cells
Add a Button to Clear the Cells
To make it easier to clear the cells, you could record a macro while you select and clear the named range.
Then, add a button to the worksheet,
and assign your macro to that button.
_______________
Thank you for the explanation of creating a macro to clear data. My form is now perfect!
So what would be the VBA code for the button to clear the cells..?
The easiest way to get the correct VBA code is to record a macro while you select and clear the named range.
Then the code will be specific to your workbook and named range.