udigold1
12-15-2008, 12:50 AM
Hi,
I having a a bit of a problem, let's say I have 2 variables on my worksheet: Quantity, Price and Total (=Quantity * Price)
when I'm using formula like this: Range("total").formula = Range("quantity) * range("price"), I get the value only, but I want the formula itself to appear, so if I change either the price or the quantity the Total will change. How do I do that?
thanks,
Udi
I having a a bit of a problem, let's say I have 2 variables on my worksheet: Quantity, Price and Total (=Quantity * Price)
when I'm using formula like this: Range("total").formula = Range("quantity) * range("price"), I get the value only, but I want the formula itself to appear, so if I change either the price or the quantity the Total will change. How do I do that?
thanks,
Udi