On 8/5/2014 at 10:21:36 AM Claus Busch wrote:

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.

Thanks, Claus.
Is there a quick way to jump from one highlighted "#N/A" cell to the
next one? Otherwise I have to go though the whole big spreadsheet many
times in order to find all the cells that are highlighted...

--
tb