xpath error? Runtime Error 13 type mismatch

S

SteveM

I am running the following code and get Runtime Error 13 type mismatch
The locals window for GetData shows xpath with the following message
: XPath : <The specified range is invalid due to one or more of the
following reasons:
•The range refers to cells in more than one column.
•The range contains mapped cells from more than one XML


Set GetData =
Range("Retrive_Data_Range").Offset(rowOffset:=Range("Index_Num").Value)
******Error appears to happen in the line of code below******
Range("Original_Import_Data").Value = Application.Transpose(GetData.Value)
Range("Revised_Data").Value = Range("Original_Data").Value


Notes
Range("Retrive_Data_Range") is set to the first row of data that I store
Range("Index_Num") resulting index # from a combobox
Range("Original_Import_Data") full stored customer dataset
Range("Revised_Data") is a subset of ("Original_Import_Data") used to track
user changes
Range("Original_Data") the same subset of ("Original_Import_Data") used to
track user changes
 
S

SteveM

after further research this is only happening in records where I have more
than 256 characters (including spaces) in one cell.

Does anyone know a way arond this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top