| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XL3Address"
(Created page with 'Returns a reference to the parameter range that can be used by other formulae, for example the XL3Link formula. ==Syntax== {{Code|XL3Address( Range )}} ==Parameter…') |
(→Parameters) |
||
| Line 13: | Line 13: | ||
| The range to create a reference for. | | The range to create a reference for. | ||
|} | |} | ||
| + | |||
| + | You should only pass a cell/range to XL3Address, not text. If you already have the cell address as text you do not need to use XL3Address. | ||
| + | |||
| + | OK: | ||
| + | |||
| + | {{code|XL3Address(Sheet1!A1)}} | ||
| + | |||
| + | No not use: | ||
| + | |||
| + | {{code|XL3Address("Sheet1!A1")}} | ||
==Examples== | ==Examples== | ||
Latest revision as of 09:15, 20 July 2023
Returns a reference to the parameter range that can be used by other formulae, for example the XL3Link formula.
Contents
[hide]Syntax
XL3Address( Range )
Parameters
| Parameter | Description |
|---|---|
| Range | The range to create a reference for. |
You should only pass a cell/range to XL3Address, not text. If you already have the cell address as text you do not need to use XL3Address.
OK:
XL3Address(Sheet1!A1)
No not use:
XL3Address("Sheet1!A1")
Examples
See XL3Link for examples.
