> For the complete documentation index, see [llms.txt](https://docs.coherent.global/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.coherent.global/assistant/custom-functions/xcall-legacy-functions/setinput.md).

# SETINPUT

Returns the absolute address of entered range or named item.

Syntax: `CS.SPARK_SETINPUT(input_location)`

Returns the absolute address of entered range or named item.

{% hint style="warning" %}
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.
{% endhint %}

| Parameter           | Description                                                                                                          |
| ------------------- | -------------------------------------------------------------------------------------------------------------------- |
| `input_location` \* | 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:

| Formula                   | Result        |
| ------------------------- | ------------- |
| `=CS.SPARK_SETINPUT(age)` | `Sheet1!$G$3` |