By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills

Step 587 - =iferror

The =IfError Excel function is useful to handle errors that may come from formulas.

It will handle any of the common Excel # errors such as

#N/A

#Name

#Div/0

#Ref

and allow you to substitute a value.

This could prevent your VBA code from getting stuck.

s = [=IfError(223/0"Error")]

If the formula causes an error then the program can handle it.