F5 Special Formulas [uncheck everything except] Errors Ok Delete

But we can also help you modify your formulas so that the errors don't
appear in the first place.

Tim C

"Lee Harris" wrote in message
...
Is there a way, after the fact of selecting a large range, and
automatically clearing the contents of any cell with #N/A as a result of
unmatched VLOOKUP or similar.

tks