Examples that use XL3GridMember.
Form 1
Used in conjunction with XL3Link, the formula below copies the unique name from the row when the report user clicks on "..." into the cell $A$14:
=XL3Link(XL3Address($D$7),"...",,XL3Address($A$14),XL3GridMember(A7))
Form 2
The second structure provides a more dynamic way to address the members that appear on the grid, for example:
Return the first member from the first hierarchy on columns:
=XL3GridMember("My Grid",1,1,1)
In the above example, this is: [Geography].[Geography].[All Geographies]
Return the nth member from the first hierarchy on rows:
=XL3GridMember("My Grid",2,1,nth)
You would only need to consider the hierarchy number if the Axis has cross-joined hierarchies.
