ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   worksheet function in VBA (https://www.excelbanter.com/excel-programming/287930-worksheet-function-vba.html)

Gabriel[_3_]

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


All times are GMT +1. The time now is 07:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com