You're welcome. Thanks for letting me know that it worked for you.

HR wrote:
I made the changes to the program and it worked like a champ. I am rolling
out a spreadsheet to 100 salespeople that use EXCEL 2000 and now the
spreadsheet works. I had previously rolled out the spreadsheet and had major
problems since I had written the macro to work on Excel 2002 (where is
works). Thanks again your a life savor.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html