I believe this changed in Excel 2007 (from 2003) where this worked
.Characters(1, l).Font.Color = RGB(153, 51, 0)
I thought it was now .Font.ColorIndex but that didn't work either.
Also, is there any way to debug.print all elements before ".Characters" to check what they are?
Thanks.