Funtion to return array - shows only one variable

[dax2ib]

I defined a below fucntion in VBA as variant which got executed and is working fine however i am not able to retrieve all the values in the excel front end.

Below is the snippet

Please Login or Register  to view this content.

However when i run the function from the front end

{=Price(A1,A2,A3)} - Its returning only one value Price1 as output. What needs to be modified to get the other two values stored in the array?

[dax2ib]

If i keep the break point and do a quick watch of Price, i am able see all the three values stored in the array. I am not able to see those three values however in the front end

[Andy Pope]

The array will not be returned to a single cell. Instead you will need to select 3 cells and array enter the formula.

[dax2ib]

Yeah. It works now.

But only when i select the cells horizontally it is working. If i select the cells vertically its just returning the same value stored in the first array variable. Any reason for that?

[Andy Pope]

you would need to alter the construct of your array.

Please Login or Register  to view this content.