Why isn't this code to change the font colour working?
On Oct 18, 7:52*am, Barb Reinhardt
wrote:
How about (not sure why you have .. instead of . either)
.Cells(MatchLineNum, 22).Font.Color = xlThemeColorLight1
Still not working (with that, or any other colour). It simply doesn't
change the font colour at all.
I've searched this newsgroup's past answers and it appears a lot of
people had issues with it. I've managed a workaround by using a
select, copy, paste method instead of changing the .font.color
property, but why doesn't the .font.color property work? Is it just
2007, or earlier versions as well?
Travis
|