VB6.0 and Excel

[Mark]

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?

 

[pikus]

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

3 = Red
Other #s = other colors

- Piku

 

[Ron de Bruin]

You can use ColorIndex

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