View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Cush Cush is offline
external usenet poster
 
Posts: 126
Default Delete words in cell if that word is in red

Without actually doing this I can tell you how I would go about finding
the solution:
Turn on your macro recorder.
Type some words in a cell, making some letters red in the middle of the text.
Turn off the recorder.

Look at the recorded code to see what property makes the font red for
certain letters

Then use that property to loop through the text in a cell and delete
any character with that property.

Hope this helps get you started

"kaiser" wrote:

Hi,

I would like to run a macro that looks at each word in a cell, and if
that word is in red, delete the word

Can anyone help me do this?