Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|