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!.



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

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.


"Alan" wrote in message
...
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