View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Lars-Åke Aspelin[_2_] Lars-Åke Aspelin[_2_] is offline
external usenet poster
 
Posts: 913
Default (FAO "Mike H") Multiplying cells using vb codes??????????

On Sun, 14 Dec 2008 07:55:00 -0800, Tdp
wrote:

Mike H,
You gave me the following code sum cells.
UserForm1.TextBox321.Text = WorksheetFunction.Sum(Range("BR4:BR14"))
Which works great................Thanks.

I have one more question, how do I Multiply to cells together using the same
code?



Replace the Sum part of your code with Product, like
Product(Range("A10","C13"))
if cells A10 and C13 are the two cells you want to multiply.

Hope this helps / Lars-Åke