Check out Chip Pearson's Site

http://www.cpearson.com/Excel/MissingReferences.aspx

"Barb Reinhardt" wrote:

I have a workbook that uses a reference that may be missing. Is there some
way I can test for it before execution so that an error specifically about
the reference is displayed?

Thanks,
Barb Reinhardt