Can someone please help me with a short sub routine that shows how to copy only the fonts, basically just the color fonts, from one range to another range; ie copy only the colors not the values from one range of text to another range of text. I have looked everywhere and their are no Excel functions that will do this and I can't figure out how to do this in vba. xlspastespecial doesn't recognize the font values.

Thanks very much,

Andrew
andrew1.aloha.@gmail.com