Ron,

Before changing A1, copy B1 and pastespecial it as a value over the formula
in B1.

HTH,
Bernie
MS Excel MVP


"rbane" wrote in message
...
Can anyone please help me with this problem ?

Assume I have a row of cells named B1 and B2.
Today I want the value in B1 to be the product of A1 times A2.
Tomorrow, I will create another row of cells named C1 and C2. I will
change
the value of A1 and I want the value in C1 to be the product of the new A1
times A2.
I do not want the old value in B1 to change from what it is today.
Can you help me with this?

Thank you very much,

Ron



--
rbane