How to find invalid formula references with VBA

[Alan]

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]

Are you talking about #REF! errors?

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

 

[JLGWhiz]

You have me confused. what is it that makes the formula invalid? It seems
that if they have bad references the error would be self evident, because
you would get the wrong result.