Returns the member's unique name for the specified grid cell. This can be useful when you want to get the unique name of a particular member from a grid for passing as an XL3Link parameter or to use in other formulas (VLOOKUP, XL3Lookup, etc.) - avoiding any issues with duplicate/translated captions, etc.
Syntax
XL3GridMember( )
Parameters
The parameters can take one of two forms:
| Parameter | Description |
| Grid cell location | Shows member's unique name for grid cell |
or
| Parameter | Description |
| Grid name | Name of the grid to get the member for |
| Axis | 1 for Columns, 2 for Rows |
| Dimension | Hierarchy on the axis to look at, 1-based. |
| Member Index | Member index to look at, 1-based. |
Limitations
An individual cell can only include one reference to an XL3GridMember(Address). You can use XL3Address for more then one reference:
=XL3GridMember(XL3Address(C13)) & " - " & XL3GridMember(XL3Address(D13))
