product of two cells
 

hi
i am having a worksheet like
a b c
1 2
in the column c i have the product of the two cells a and b in coding
will you can tell me how to solve this problem........

product of two cells
 

One way:

Public Sub Product2Cells()
Range("C1").Value = Range("A1").Value * Range("B1").Value
End Sub


In article
,
wrote:

hi
i am having a worksheet like
a b c
1 2
in the column c i have the product of the two cells a and b in coding
will you can tell me how to solve this problem........