![]() |
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