When I dim Period1, Period2 & Period3 as String, I still get an Object Required error, this time pointing to my Set Period1 statement. I changed the dim from string to variant and the code worked without any problems.

Thanks for all of your help!

Sirius