Thanks for the add'l info. I tried pasting it into the VBA editor at home and it worked fine so there's something lost in translation by my sending the code to the office so I'll send my template file home and past the code there, which I'm sure will then work.

-Rich