Thread: VALUE Error
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default VALUE Error

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