add_name
Define a named range or formula in a workbook to simplify cell references for calculations and data analysis.
Instructions
Define a named range (named formula) in the workbook, e.g. name "TaxRate" for "=Sheet1!$B$1".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ref | Yes | Reference formula, e.g. "=Sheet1!$A$1:$D$10". | |
| name | Yes | Name to define, e.g. "TaxRate". | |
| comment | No | Optional description. | |
| workbookId | No | Target workbook ID from list_workbooks. Optional when only one workbook is connected. |