Help Centre › Building Processes
This article describes the RPA Excel functionality to create a named range.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Add named range function creates a named range in the workbook. Named ranges allow referencing a cell or range of cells by a friendly name instead of an address, making formulas easier to read and maintain.
Setting it up
To use the EXCEL Add named range function, follow these instructions:
{{popups:rpas/add:action=excel-add-named-range}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Add named range function
- Click on the green button's drop-down (right side of the green button labelled "Process")
- On the menu that appears, click on the "+ Activity" item
- From here you can select the EXCEL Add named range option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| File path | Yes | Text | – | Full path to the Excel file. |
| Sheet | Yes | Text | – | Name of the sheet containing the range. |
| Range name | Yes | Text | – | Name for the range (e.g. TotalSales). |
| Range address | No | Text | Current cell | Range address (e.g. A1:B10). Defaults to the current cell. |
Output variables
This action does not produce any output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open. |
| Sheet not found | The specified sheet does not exist. |
| Invalid name | The range name contains invalid characters or is a reserved word. |
Tips
- Named ranges make formulas more readable, e.g. =SUM(TotalSales) instead of =SUM(A1:A100).
- Range names cannot contain spaces. Use underscores or camelCase.
- If the range address is omitted, the currently selected cell is used.