Are you talking about #REF! errors?

If yes, then you can record a macro when you use Edit|Find and look for #REF!.



Alan wrote:

Is there a way to use VBA to find invalid formula references in an
Excel spreadsheet?

I have some input worksheets I cannot control, and sometimes they
contain invalid formula references. I simply want to delete those
rows. I know how to delete the rows, but not how to find formulas
with problems.

Thanks, Alan

--

Dave Peterson