Can I use the excel IsError function in VBA code? I have a refresh timer running every five secs, and from time to time, some cells contain !NULL#. This is a result of a add-in bug. I am checking for the string "!NULL#" right now, but it doesn't seem to work. I'm using something like:
if cells(6, 1).value = "!NULL#" then
do something
else
do something else
end if
Any ideas?
if cells(6, 1).value = "!NULL#" then
do something
else
do something else
end if
Any ideas?