Hi everyone!

I have an Excel problem which I have been trying to solve for a while but so far I have had no luck. A friend recommended this forum, so I am really hoping you guys can help!

I need a VBA script that can copy only text that has a font color of red from a cell. The cell has both black and red text. I then need to copy the result into an adjacent cell.

An Example (A1):-

This is an example of a cells content.

It has both red and black text.


I want the macro to search through column A and copy only the text in each cell that is red.

The result in (B1) will be:-

example of a cells

red


Could anyone help me?

Many thanks in advance!

Mark