Just to clarify:You're saying that you have a formula in column C that refers
to column B, and that the formula in Column C is being wiped out by the macro
above?
--
p45cal

Thanks, that works to perfection, however I also have an equation I
want to use involving column B and since the value is being replaced
in column C, the formula automatically clears itself out as soon as I
put something in column A.