IsError function is to check any expression contain error value or not and return in Boolean either True or False.
Syntax : IsError(expression) , Return : True/False
Below example Range D2~D6 contain formula which create error because of formula.When we test this range with IsError function cells contain #NULL error show TRUE result and others FALSE.
VBA Vode:
Option Explicit
Sub Examples_IsError()
Dim i As Integer
i = 2
With ActiveSheet
Do
.Range("E" & i) = IsError(Range("D" & i))
i = i + 1
Loop Until .Range("A" & i) = ""
End With
End Sub
Sub Examples_IsError()
Dim i As Integer
i = 2
With ActiveSheet
Do
.Range("E" & i) = IsError(Range("D" & i))
i = i + 1
Loop Until .Range("A" & i) = ""
End With
End Sub
Note:
The error generate in Excel included #DIV/0,#N/A,#NAME?,#NULL!,#NUM!,#REF!,#VALUE! and #####. May be circular error also included.
Microsoft Reference-Iserror-functionOther Reference-Iserror-function.htm
Other Reference-Iserror.php
Practice makes perfect. Thank You.
macro enabled excel
excel macro
vba coding
vba code
