Type mismatch passing arrays via COM
 

I'm trying to pass an array from my VBA app into managed COM
component but am getting "Type mismatch: array or user-defined type
expected error" on the array name where it's being used as a parameter
to the COM call.

The COM method (in C#) is declared as follows:

[ComVisible (true)]
public void TrippleArray(ref double[] input)
{ /*implementation*/ }


I'm trying to call it in VBA using this:

Dim tester As New MyAddin3.Connect
Dim inputNums(10) As Double
' load numbers into inputNums

tester.TrippleArray (inputNums)