# CLEAR EXCEL RANGE

### Ranges:

To specify a cell reference in Ranges: use one of the following formats:

1. start_cell:end_cell (eg. A5:A25 )
2. start_cell (eg. A5 )

The first or second format is valid for: Types: Normal Range

Only the second format is valid for: Types: Row or Column

### Multiple Ranges

More than one cell reference or NAMED RANGE may be specified in the Ranges: parameter by comma separating the values.

Thus a single CLEAR EXCEL RANGE may clear the values from cells within multiple spreadsheets.

For every cell reference or NAMED RANGE specified in the Ranges: parameter, a corresponding value must be specified in each of the Sheets: and Types: parameters, so that all three parameters contain the same number of entries.