Passing array to procedure gives type mismatch error

**welchs101** · 01-14-2015, 07:51 AM

Hi,

I have run into this scenario before and in the past i have always fiddled around with the code to get my code to run without really ever "learning" why this problem occurs. I have read a few links and passages in books on arrays and passing arrays and have not really found my answer so i am going to post my issue here and hope someone can explain it to me.

Consider the following code:

Please Login or Register  to view this content.

if i try to run the above code i get a type mismatch error. However, if i change the declaration for temp_array1 from

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

It runs fine..........

Can someone explain why?

Also, why does having "()" around declaration in procedure "pass_array_procedure2" cause an error?

I just never know when to include "()" or how to declare my variant-arrays in the main procedure.

**Kyle123** · 01-14-2015, 08:08 AM

pass_array_procedure2 is explicitly stating that it will only accept an array. At compile time the application doesn't think that temp_array1 is an array so you get a type mismatch error.

If you change:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Both will work as you've told the compiler that temp_array1 is an array

**romperstomper** · 01-14-2015, 08:10 AM

With your original code, temp_array1 is a Variant, not an array, which your second procedure requires. The fact that temp_Array1 may happen to contain an array does not alter that.

Declaring the variable as an array solves that issue - the first procedure will still accept it since an array is always Let coercible to a Variant (i.e. a Variant can contain anything, including an array).