PDA

View Full Version : Simple multiplication



domm1988
05-16-2012, 03:22 AM
Got value in "A1" want to multiply by variable x assaigned to value in "B2"

Following code gives an 0 value result

Dim x As Double
x = Range("B2").Value
Range("A2").Value = Range("A2") * x

Kenneth Hobs
05-16-2012, 06:14 AM
Then A2 or B2 is 0 or blank already because 0 times any number is 0.

domm1988
05-16-2012, 06:34 AM
Yes it works now

CatDaddy
05-16-2012, 09:26 AM
Dim x As Double
x = Range("B2").Value
Range("A2").Value = Range("A2").Value * x