Posted to microsoft.public.excel.programming

Gabriel[_3_] Gabriel[_3_] is offline

external usenet poster

Posts: 17

worksheet function to 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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
if worksheet function	supersonikk	Excel Worksheet Functions	9	April 8th 08 07:59 AM
Worksheet Function	JeremyH1982	Excel Discussion (Misc queries)	4	May 9th 07 09:31 PM
Get a Worksheet name through a function	Tetsuya Oguma	Excel Worksheet Functions	2	March 10th 06 03:29 AM
Reference the worksheet from a multiple worksheet range function (	DBickel	Excel Worksheet Functions	1	May 28th 05 03:49 AM
Can the offset worksheet function reference another worksheet	AlistairJ	Excel Worksheet Functions	2	May 9th 05 06:18 PM

All times are GMT +1. The time now is 08:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us