macro to determine colour of text in rows

T

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.
 
B

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)
 
T

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)
Click to expand...
 
Top