Record a macro when you select a range (or all the cells)
edit|goto|Special
Errors

You'll be able to record a macro when you search for constants with errors and
formulas with errors. So you'll end up with two macros.

viking4020 wrote:

I wish to write vba code that finds occurrences of #N/A, #NAME, etc in Excel
spreadsheets.

--

Dave Peterson