Hi, I'm new to makro programming with oo, but I have some experience in programming.

I want to make some special statistical calculations and thought to use a makro for that.

I thought the easiest way would use a function which will return the desired value, so I need to get the values from the table like 'A1:A12' and put them in an array that the function can use. I have so far searched the help and the net but found no concrete answer to that. I understand the VOL(a;b;c) example, but this uses only single cells and I want/need to use a range.

I want to type in the spreadsheet

=myFunction(A1:A12)

My thought for the function so far

FUNCTION myFunction(array())

--my calcutaltion

myFunction = value

END FUNCTION

So I like to use the array like

array(0)=A1

.

.

.

array(11)=A12

The length of the array need to be dynamic.

I hope some one can give me a clue how to make this work.

Thanks