Hi,

1. Select the entire range and press F5, Special, Constants, and uncheck
Numbers and click OK. If all cells are numeric you will get a message
otherwise they will all be selected. You can press Tab or Shift Tab to move
from one to the next without breaking the highlighting.
You can also press Enter or Shift Enter as an alternate way to move through
all the found cells.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"pcor" wrote:

I have a large spreedsheet from L2 to BE 1268
The majoority of the cells contain data. It appears that not all the data is
NUMERIC as I am getting VALUE errors. I would like a macro that would check
all the cells to see which one are NOT numeric so that I could change them to
MUNERIC and avoid all the VALUE errors I am getting
Going accross from l to be I need 4 different totals( I total col L,M,N,s,t u
an other total might total the following col O,P,Q,R etc etc
Thanks