| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Type Mismatch Error - Help Please | Excel Worksheet Functions | |||
| Macro error type mismatch | Excel Discussion (Misc queries) | |||
| Type Mismatch Error | Excel Discussion (Misc queries) | |||
| Runtime Error 13 - type mismatch | Excel Discussion (Misc queries) | |||
| Why type mismatch - R/T error 13 | Excel Discussion (Misc queries) | |||
Linear Mode
