Hi Max,

Thanks again. I did try that too.
I solved my problem by looping through each cell in the ranges and
re-setting the the values to the existing values. This took away the bug I
was experiencing.

For each cell in Range(A3:A398)
Cell.Value = Cell.Value
Next

"Max" wrote in message
...
"AD108" wrote:
I tried that, but it's still doing the same thing. If I select the
cell,
press F2 and then enter, the error goes away. I tried reformatting them
also. Weird.

Wondering whether calc mode has anything to do with it? Could it be
inadvertently set to Manual? Press F9, does it now compute? Check and
ensure
calc mode's on Automatic via: Tools Options Calculation tab
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---