Thread: #N/A In Cells
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
tb tb is offline
external usenet poster
 
Posts: 84
Default #N/A In Cells

On 8/5/2014 at 2:31:52 PM Claus Busch wrote:

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.


Thanks Claus and Gord.

--
tb