LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default Variant Array with String Values - Type Mismatch

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to check a Variant for its data type TBA[_2_] Excel Programming 5 January 9th 04 11:04 PM
variant array containing cel adresses convert to actual ranges-array Peter[_21_] Excel Programming 5 December 10th 03 09:50 PM
Type mismatch? string 2 a long?? CAA[_2_] Excel Programming 4 December 9th 03 02:34 PM
setting ctl to array of checkboxes yields type mismatch error. tritan Excel Programming 0 July 11th 03 09:22 PM
setting ctl to array of checkboxes yields type mismatch error. Tritan Excel Programming 0 July 11th 03 07:50 PM


All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"