I looked at the macro code that I had, and it looked pretty similar to what you posted, except the line referring to font color just wasn't there. I popped that in there and now the macro works as I desired. Just wondering why that step wasn't recorded in automatically. I tried recording it several times, always with the same result. Anyway, now I have what I wanted, thank you.