#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
|