macro to determine colour of text in rows

[Tino]

Hi,

What would be the macro commands to determine the colour of the text
in a cell in a Microsoft 97 spreadsheet?

Any help would be much appreciated.

Thanks.

 

[Bob Phillips]

Activecell.Font.ColorIndex

you can get the colours by looking at the ColorIndex Property in VBA Help(3
is red for instance)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tino]

Thanks... again.

Activecell.Font.ColorIndex

you can get the colours by looking at the ColorIndex Property in VBA Help(3
is red for instance)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)