SETINPUT

Returns the absolute address of entered range or named item.

Syntax

CS.SPARK_SETINPUT(input_location)

• input_location: Required. Address of the range that will be used to return the absolute address. You can also use named items for convenience.

Example

Given that the below formulas are pointing to ranges that are located in the worksheet called Sheet1

Formula	Result
=CS.SPARK_SETINPUT(A1)	Sheet1!$A$1
=CS.SPARK_SETINPUT(A1:B9)	Sheet1!$A$1:$B$9

Assume that we have a named item age that points to G3:

=CS.SPARK_SETINPUT(age)	Sheet1!$G$3

If you update the name of the sheet where the named item or selected range is located in, the formula won't update automatically. You will need to refresh it manually.