Thread: #N/A In Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default #N/A In Cells

Hi,

Am Tue, 5 Aug 2014 15:13:14 +0000 (UTC) schrieb tb:

Is there a formula that will quickly point out to me which cells of the
main spreadsheet have the "#N/A" in them?


Start = Find & Select = Go to Special = Formulas = Errors
will select all formula cells with errors


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional