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?
|