Thanks for the repsonse Tom

I've gotten the code to work for a set number of rows, but is there a
way that I can have the loop repeat as many times as there is data or
until it reaches the first row that is blank. I would like to know so
that when I add or delete rows I do not have to modify the macro as
well.
Any thoughts???

Bob Belforti


---
Message posted from http://www.ExcelForum.com/