Function
 

I need to write a program that calls a function and takes
2 ranges (which are selections) and multiplies them
together, and prints the results on a 3rd sheet. I am a
little lost.

Function
 

Why a program?

=SUMPRODUCT(Sheet1!A1:A10,Sheet1!B1:B10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dale Marques" wrote in message
...
I need to write a program that calls a function and takes
2 ranges (which are selections) and multiplies them
together, and prints the results on a 3rd sheet. I am a
little lost.

Function
 

I need to multiply corresonding cells together, the first
cell from range 1 and the first from range 2. Then
display the product of those two, and move on to cell two.
-----Original Message-----
Why a program?

=SUMPRODUCT(Sheet1!A1:A10,Sheet1!B1:B10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dale Marques" wrote in message
...
I need to write a program that calls a function and
takes
2 ranges (which are selections) and multiplies them
together, and prints the results on a 3rd sheet. I am a
little lost.


.

Function
 

Not to labour the point, why not just put =A1*B1 in C1, and then copy down?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

wrote in message
...
I need to multiply corresonding cells together, the first
cell from range 1 and the first from range 2. Then
display the product of those two, and move on to cell two.
-----Original Message-----
Why a program?

=SUMPRODUCT(Sheet1!A1:A10,Sheet1!B1:B10)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Dale Marques" wrote in message
...
I need to write a program that calls a function and
takes
2 ranges (which are selections) and multiplies them
together, and prints the results on a 3rd sheet. I am a
little lost.


.