LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 21
Default Setting Error #VALUE,#REF,#NAME, etc.

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?
 
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 03:37 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"