I have created the following schema and added it to my spreadsheet:

<?xml version="1.0" encoding="UTF-8" standalone="no" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <xsd:element name="Parts">
    <xsd:complexType>
      <xsd:sequence>
        <xsd:element minOccurs="0" maxOccurs="unbounded" name="Part">
          <xsd:complexType>
            <xsd:sequence>
              <xsd:element name="id" type="xsd:string"/>
              <xsd:element name="description" type="xsd:string"/>
              <xsd:element name="mansite" type="xsd:string"/>
              <xsd:element name="period" type="xsd:string"/>
              <xsd:element name="fcyear" type="xsd:string"/>
              <xsd:element name="units" type="xsd:integer" />
              <xsd:element name="type" type="xsd:string" />
              <xsd:element name="source" type="xsd:string" />
            </xsd:sequence>
          </xsd:complexType>
        </xsd:element>
      </xsd:sequence>
    </xsd:complexType>
  </xsd:element>
</xsd:schema>
and added the following code to my spreadsheet to map just one of the elements:

    Set xp = Sheets("My Sheet").Range("A1").XPath
    xp.SetValue xmp, "/Parts/Part/id", , True
When I then look at the mapped range only the first two cells on the sheet are being mapped instead of the whole column. How can I change it so that the map incorporates the whole column?

Thanks