Hello :)

I have been researching this and there seems to be many differen
suggestions none of which I have been able to get to work.

I am trying to say that if column A becomes null ("") [I have als
tried .value = 0] the offset values become null as well. Here is th
problem:

1) When I delete an entry in column A nothing happens to the row value
until A loses and then regains focus. Is this typical?

2) When column A then regains focus, I lose the formatting and th
formulas in the row.

I know I am close on this but I just can't seem to find the righ
formula.

Does anyone know the correct formula to achieve this?

Thank you very much in advance for any tip

--
Message posted from http://www.ExcelForum.com