Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to find the ColorIndex of words within a cell?

Status
Not open for further replies.

traceyr

Technical User
Aug 16, 2002
41
DE
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!
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top