Hi Don,

The macro does exactly what I was hoping it would do. I thank you again for your hard work.

I was wondering if you might have any suggestions for getting this to run more efficiently in a large spreadsheet. I currently have about 34,000 lines and almost 4,000 of them have the dashes (----) and it takes 15 minutes to run.

Any suggestions are appreciated.

Thanks again for your help,

Dan