View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lee Harris
 
Posts: n/a
Default Clearing #N/A's in one go?


"Tim C" wrote in message
...
F5 Special Formulas [uncheck everything except] Errors Ok Delete

But we can also help you modify your formulas so that the errors don't
appear in the first place.

Tim C



thanks, I think I am OK using the ISNA wrapper in my formulas, but when
you've typed out a long, complex formula sometimes I can't be bothered to
put it in - your tip will be a great time saver thanks!