worksheet function to vba

G

Gabriel

Hi,

I have a table (A1:C3)
0.01 0.023 0,032
0.02 -0.025 0.01
-0.03 0.045 0.02

I want to convert the folowing expression {=PRODUCT(1+A1:A3)} for each
column in vba.

Ideally, I should be able to select the output range (F1:F3) and then
interact with the vba user defined function to select the input range
(A1:C3) and get the results for each series.

Thank you in advance
Gabriel
 
Top