E
ExcelMonkey
I want to create a function which returns an array. For Example I want
ArrayFunction to return X,Y.
I will then load the results of the Function into a 2D Array with 2 colums:
Private FunctionArray(A as String, B as String) As Variant
'This needs to produce a result that looks like X,Y
End Function
How do I set up the function to return an array result (2 values)?
Thanks
EM
ArrayFunction to return X,Y.
I will then load the results of the Function into a 2D Array with 2 colums:
Private FunctionArray(A as String, B as String) As Variant
'This needs to produce a result that looks like X,Y
End Function
How do I set up the function to return an array result (2 values)?
Thanks
EM