SET_NAME

Syntax:

SET_NAME(name:Text, expression)

Sets the name to be the expression.

Example:

SET_NAME("TAX_RATE", C2)

sets the name TAX_RATE to be the reference C2. Other calculations can use the name TAX_RATE in their calculations, and the reference C2 will be used whenever TAX_RATE is named as a parameter.

Note that although you must specify the name within quotes when defining it using the SET_NAME function, you would not put it in quotes when referring to it elsewhere in the worksheet.

You can use this function to set a name for any external references you use.

Setting a name in the supporting document and using it from the dependent document will enable you to edit the supporting document without the dependent document loaded, and without the risk of cell references becoming out of date.