View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gabriel[_3_] Gabriel[_3_] is offline
external usenet poster
 
Posts: 17
Default worksheet function in VBA

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