NAMED RANGE's are created automatically by EASAP Builder by reading them directly from spreadsheet files specified within a SPREADSHEET. NAMED RANGE's can be used within Range Reference: parameters of data entry objects (INPUTBOX, CHOICE LIST, etc.) and Ranges: parameters of Excel actions (READ EXCEL ACTION, WRITE EXCEL ACTION, etc.).
A NAMED RANGE can specify additional information; for example, when a dimension is needed via the Unit: parameter or when overriding the cell type using the Cell Type: parameter.
|Select named range from list
|Comma-separated list of cells dependent on this referenced cell. Set automatically by dependency calculation.
|Comma-separated list of dependent cells beyond calculated values. NOTE: Re-run dependency calculation after setting. ( [1!A5] = Cell A5 in Sheet 1)
|Select unit of value stored in cell. Should be set when value in cell is NOT in the base unit used in EASAP for this value.
|Set whether the cell is an input or output, or both.
|The Excel formula pointing to to the cell.
Below is an example of a NAMED RANGE: