PDA

View Full Version : Solved: {Solved}calculation:multiply



Yjmmay34
05-25-2010, 11:53 PM
hi, all. I want to multiply two numbers from different cells. But there is an error said type mismatch. Does anyone know this problem??
Thanks in advance.


Range("D4") = totalQ1LU
Range("E4") = totalQ1POC
Range("G4") = totalQ1LUR
Range("F4") = "=(" & totalQ1LUR & "/" & totalQ1LU & " )"
Range("H4") = "= (" & totalQ1POC & "*" & Cells("4F").Value & ")" 'this row get the error