Hi all,
I thing there is a bug in excel 2013 64-bit on win7 because I can't use Application.Caller with IsError(), IsEmpty(), IsNull(), ...
IsMissing() does seem to work though
for example:
Any Cell containing =funcBug() produces this error:
"Careful, we found one or more circular references in your workbook that might cause your formulas to calculate incorrectly"
Function funcBug()
vTemp = myFunc(Application.Caller)
funcBug = 3
End Function
Function myFunc(oRange)
Debug.Print IsEmpty(oRange)
End Function
Bookmarks