i'm looking for a FALSE return value from these functions if they can't find the data. I don't know if i get that as well, but currently, macros just interrupted by dialogue box that says "Microsoft Excel can't find the data you are looking for".

i'd like to supress that response and simply have the function return FALSE if possible.

thanks,

brian