formula error query

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

Guest

Hi All,
I'm looking for a VBA help if there is a cell with "#DIV0!" error. How can I
track it down and jump over this cell?
I treid Application.WorksheetFunction.IfError but couldn't figure how to use
it.
Thanks a lot.
 
You could use this, but it would skip over any cells with errors, not
just the division by zero errors.
If WorksheetFunction.IsError(ActiveCell) Then
MsgBox "Error"
End If
 
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

comparing strings 6
Excel VBA 1
HELP!!! I can't set formula to cell 1
Excel JUMP FROM SEARCH BAR TO RESULT 3
JUMP FROM "SEARCH" CELL TO RESULT WHEN PRESSING ENTER 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
passing a non numeric cell for numeric comparison 2
Delete rows based on contents of Col A 0

Back
Top