View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan[_8_] Alan[_8_] is offline
external usenet poster
 
Posts: 117
Default How to find invalid formula references with VBA

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