Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
I'm sure there's a simple answer, but for the moment I'm stuck and I have a deadline to meet. I have declared a three dimensional array as being of variant type and then assigned various values to the array. Some of the values assigned are numerical, some are strings. Part of my code compares the values in the array. When comparing values that contain numerical values there is no problem, yet when comparing values that are strings I get the type mismatch error. If one value was numerical and the other was a string I could understand why this is, however I have checked that the two values are both strings. Anyone know what I'm doing wrong? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to check a Variant for its data type | Excel Programming | |||
variant array containing cel adresses convert to actual ranges-array | Excel Programming | |||
Type mismatch? string 2 a long?? | Excel Programming | |||
setting ctl to array of checkboxes yields type mismatch error. | Excel Programming | |||
setting ctl to array of checkboxes yields type mismatch error. | Excel Programming |