VB6.0 and Excel
 

I am referencing a Excel object from a VB 6.0 application
and I can't set the font color of an individual cell. How
do you do it?

VB6.0 and Excel
 

Cells(1, 1).Font.ColorIndex = 3

3 = Red
Other #s = other colors

- Piku

--
Message posted from http://www.ExcelForum.com

VB6.0 and Excel
 

You can use ColorIndex

Range("a1:a10").Font.ColorIndex = 3


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Mark" wrote in message ...
I am referencing a Excel object from a VB 6.0 application
and I can't set the font color of an individual cell. How
do you do it?