VBA error check using Excel functions
 

aha!

I was also thinking of actually writing a loop using the "like
operator that would operate like the match function does in excel, bu
vb still chokes on the #N/A when used as a comparator

--
Message posted from http://www.ExcelForum.com