xpath error? Runtime Error 13 type mismatch
 

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:=Rang e("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

xpath error? Runtime Error 13 type mismatch
 

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?

"SteveM" wrote:

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:=Rang e("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