check cell for #REF!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do i check if a cell has #REF! anywhere in the cells formula?

ie check if Range("A1").formula =#REF! Or ='Sheet1'#REF! or any formula with
#REF! in it.

Thanks

Clayton
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Oop's I did it again! 5
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Excel Copy COUNTIF while retaining reference 7
Code to change a named range 2
Using the INDIRECT function across multiple worksheets 1
Sub to check and report any formula returned error (eg: #REF!) 5
need macro for fill down 1
Copy paste code for a #REF 2

Back
Top