Thread: #N/A In Cells
View Single Post
  #7   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 18:45:39 +0000 (UTC) schrieb tb:

1) Start = Find & Select = Go to Special = Formulas = Errors
2) Press Shift+Down Arrow in found dialog (?)
3) Close dialog
4) Tab through the highlighted cells

I don't get a found dialog anywhere when following the above-mentioned
instructions, so I am stuck at step 2.


try Start = Find & Select = Find = What: #N/A = Options = Look At:
Values
But you can also edit your formulas with my first suggestion. You only
have to press F2 to edit.


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