#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jo Davis
 
Posts: n/a
Default Error Messages

Hi

Is there a way in my settings that i can get Excel to hide formula error
messages?

any help would be most appreciated.

Cheers
Jo
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tony h
 
Posts: n/a
Default Error Messages


You have various option for handling errors.

Assuming that you are talking about worksheet functions returning error
values, rather than VBA code there are two options.

1. correct the result using something like
=if(iserror(formula),"",formula) this leaves the cell clear if the
formula returns an error.

2. cosmetically only you can use the conditional formatting (again
using the =iserror(A1) ) to set the font colour the same as the
background colour.

Just think carefully about future maintenance.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=501033

Reply
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



All times are GMT +1. The time now is 12:27 AM.

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

About Us

"It's about Microsoft Excel"