This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Download Microsoft Edge
More info about Internet Explorer and Microsoft Edge
Returns an
XPath
object that represents the XPath of the element mapped to the specified
Range
object. The context of the range determines whether the action succeeds or returns an empty object. Read-only.
Syntax
expression
.
XPath
expression
A variable that represents a
ListColumn
object.
The
XPath
property is valid when the range that it contains meets the following conditions:
The range is a single cell.
If the range consists of two or more cells, one or the other must be true:
If the cells contain XPath information, all cells in the range must contain XPath information (that is, each cell is associated with one or more data maps), and all of the cells must have identical XPath content (that is, each cell contributes to the same set of data maps).
All of the cells must contain no XPath information.
The range does not contain discontinuous areas.
The header and totals row of a table are considered to contain XPath information. Any ranges that don't meet these conditions return a run-time error.
If the range selection is valid, but none of the cells are mapped, Excel returns an
XPath
object so that you can access the
SetValue
method to create a mapping.
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see
Office VBA support and feedback
for guidance about the ways you can receive support and provide feedback.
