Returns a reference to the parameter range that can be used by other formulas, for example the XL3Link formula.
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 don't need to use XL3Address.
For example, you can use this format:
XL3Address(Sheet1!A1)
But don't use this format:
XL3Address("Sheet1!A1")
Examples
See XL3Link for examples.