Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 After some additional research this is only happening in records where I have more than 256 characters (including spaces) in one cell. Does anyone know a way around this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
xpath error? Runtime Error 13 type mismatch | Excel Discussion (Misc queries) | |||
Type Mismatch Error - Help Please | Excel Worksheet Functions | |||
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) |