Feeds:
Posts
Comments

Archive for June, 2010

This User Defined Function is designed to be used with Excel 2003, or earlier, to mimic the IFERROR functionality built in to Excel 2007 or later.

Public Function IFERROR(ToEvaluate As Variant, Default As Variant) As Variant
'Duplicates Excel 2007 "IFERROR" functionality.
If IsArray(ToEvaluate) Then
  IFERROR = IIf(IsError(ToEvaluate(1)), Default, ToEvaluate)
Else
  IFERROR = IIf(IsError(ToEvaluate), Default, ToEvaluate)
End If
End Function 
Advertisements

Read Full Post »