Wow.. It has been ages since I've asked a question.
First off.. I'm migrating from Office 2003 to 2007 ( employer issues ).
I have a project that works and it places in a cell comments.. Then on particular lines it changes the font color .. of just that line to RED here is the code that worked
Code
rngTgt.Comment.Shape.TextFrame.Characters(CInt(Split(itm, ":")(0)), CInt(Split(itm, ":")(1))).Font.Color = 16711680
I get an error stating "Font size must be between 1 and 409.
I'm hoping that Dave Hawley sees this or some other Office MVP sees this and can comment. I found this THREAD but it's from 2009 I was wondering if someone has found the workaround. Besides using the "COLOR INDEX"
and I thought that 2007 was the first excel to be able to use more colors than just the 12 or however many indexed colors there are?