How to find invalid formula references with VBA

  • Thread starter Thread starter Alan
  • Start date Start date
A

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
 
Are you talking about #REF! errors?

If yes, then you can record a macro when you use Edit|Find and look for #REF!.
 
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.
 
Back
Top