View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Gordon[_5_] Gordon[_5_] is offline
external usenet poster
 
Posts: 9
Default Setting Error #VALUE,#REF,#NAME, etc.

"Gulfman100" wrote in message
...
I am working on a work book that I want to use as a template. How do I hide
all of the errors for the formulas in the cells that appear before the
data
is entered to make the formula function. What would be the best approach?



I always used to use an IF statement.

--
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)