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
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