Since this subject is posted, I have an additional question.

How do you use an offset in a Range .Select

worksheet.Range("A1:C1") .Select

the Cell C1 is a calculated field based on number of columns being
added. I tried to use the following format that worked for mapping an
element, but can't make it work in the Range statement above. Also,
can the offset be zerio.

actColumn = actColumn + 1
set xp = worksheet.Range("A1:A2").Offset(1,actColumn).Xpath
xp.SetValue workbook.XmlMaps(1), strXPath

Thanks
Robert


--
roblo
------------------------------------------------------------------------
roblo's Profile: http://www.excelforum.com/member.php...o&userid=22469
View this thread: http://www.excelforum.com/showthread...hreadid=398684