Array as a parameter

• • Reply

  13 years ago

  by iftg

  igor

  , Russia

  Joined 13 years ago

  I need to write a procedure that would take an array of variants as a parameter. However, the data I need to work with in the calling procedure must be stored in an array of doubles.

  When I do it directly I get an error "Type mismatch". What could you suggest please?

  Report abuse
• • Reply

  13 years ago

  by ErwinB

  Erwin Bergsma

  Leuven, Belgium

  Joined 15 years ago

  Without seeing your code it's hard to give you a precise answer, but I guess you tried to pass the double array as the parameter when calling the procedure.  The type-mismatch error in that case is caused by the fact that the procedure expects an array of the Variant type, and therefore "doesn't like" the fact that you try to pass it an array of the Double-type.

  I can think of 2 options:

  1. Use the Double-type as the parameter in the procedure-definition.

  2. In your calling procedure, create an array of the Variant-type, fill it with the data from the Double-array, and then pass it on to your procedure.

  Hope this helps.

  Erwin

  Report abuse