Thread: Function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default 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.