LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
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)

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
error 13 when setting worksheet listbox Amedee Van Gasse Excel Discussion (Misc queries) 1 September 24th 08 02:06 PM
error 1004 when setting pivottable.pagefields Amedee Van Gasse Excel Discussion (Misc queries) 0 September 24th 08 01:39 PM
Setting to stop error messages from showing? JENNYC Excel Discussion (Misc queries) 5 February 24th 06 10:05 PM
Error setting shape text property Sarge Charts and Charting in Excel 2 January 11th 06 03:31 AM
off-setting points of different series b/c error bars overlap dothareggae Charts and Charting in Excel 1 July 19th 05 11:59 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"