Programming Excel with VBA and .NET

Name

xpath.Map

Synopsis

Returns the XmlMap object for a mapped range or list column. You can use the returned XmlMap object to refresh data or get information about the mapping. For example, the following code displays a list of each of the mapped cells on a worksheet:

Set ws = ThisWorkbook.Sheets("Sheet1")
For Each rng In ws.UsedRange
    If rng.XPath <> "" Then
        str = rng.Address & "Map : " & rng.XPath.Map.Name
        str = str & " Node: " & rng.XPath
        Debug.Print str
    End If
Next