Probably the numbers are text ..

Try this ..

Copy an empty cell
Select the "unresponsive" range
Right-click Paste special Add OK

This should "coerce" the text numbers to real numbers
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Gary" wrote in message
...
In some cases, AutoCalculate doesn't seem to see my data - highlighting a
range produces no responce (just as if the cells were empty). The only
way
to correct that I have found is to re-type the data (in the same cells),
and
this seems to fix the error. Do you know what causes this?