Name a range so formulas can say =SUM(Sales) instead of =SUM(Sheet1!$B$2:$B$500), and keep meaning the right cells when rows are inserted
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
Excel Instance excelInstance | variable | Required | — | — |
Action action | enum | Optional | define | —defineremove |
Name name | string | Required | — | No spaces. Sales_2024 rather than Sales 2024 |
Sheet Name sheetName | string | Optional | — | Leave empty for the first sheet Shown when action = define |
Range range | string | Optional | — | The cells the name points at, such as B2:B500 Shown when action = define |
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Close Excel Workbook
Save and close the Excel file
Convert CSV to Excel
Turn a .csv file into a .xlsx workbook. Quantities become numbers so they will sum, and reference numbers keep their leading zeros
Convert Excel to PDF
Save the workbook, or one sheet, as a PDF
Execute Excel Macro
Run an automated macro inside Excel
Recalculate Excel Formulas
Recalculate the workbook's formulas and save. Use after writing values other formulas rely on
Refresh Workbook Data
Run every query, connection and PivotTable cache in the workbook again, waiting for the background ones to finish before saving. Needs Windows with Microsoft Excel installed