No way! Thank you for the quick response macropod! you're the best!

If I have multiple excel docs open, only 1 shows up in my list. I have to close the other docs and reopen the user form in order to get to the one I want.

any ideas if I am running a setting wrong? I have the Excel 14.0 library reference included already.