Thanks for the reply. (I moved the thread also).

I will take a shot at putting your code in and seeing what happens.

Question... I have recently been upgraded to Office 2007. Might there be an issue with using Excel VBA from 2007 then saving down to 97-2003 workbook?

Thanks again David.