How to find the ColorIndex of words within a cell?

[traceyr]

I have a column of cells containing text and a macro which counts the number of words within a marked range.

What I'd really like to do is to count only e.g. blue words in all cells within the range and ignore text of other colours.
If a cell contains words of different colours, ColorIndex returns a Null value, since it can't assign a valid value if there is more than one colour present.

Any ideas?
Thanks!

 

[PHV]

Have a look at the Characters property of the Range object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[traceyr]

Thanks PHV, just what I need. Great!