[Solved] Basic Programming Custom Function Using Array

[alammohds]

I want to pass a Range from the Sheet to the Function defined using the Basic programmer. Say polynomial coefficients for x and y variables of power 4. so 2x5 Array.
Then I want to reference individual elements from the Array into the function procedure to use for calculations. e.g different coefficients of
the polynomial.

I would appreciate an example please

[Zizi64]

https://wiki.openoffice.org/wiki/Docume ... to_a_macro

Modified sample:

Passed two dimensional Array.ods

(9.92 KiB) Downloaded 97 times

Note: Only the Cell values will be passed to the user defined Basic function, but will not be passed the other parameters of the Cell range (like the coordinates of the passed cells)

[alammohds]

Thanks. Much appreciated. I was able to solve my problem