VBA code to remove/delete all text in cell range when the text is not black

[Detectiveclem]

Hi

Can anyone help me with VBA code for one worksheet please?

I want to be able to run an auto VBA code on a sheet (called "Results") so that when I copy a range of cells into cells A3:GF3 from another sheet, the text unless its black will be deleted leaving the cell blank. Therefore only those cells with black text will remain populated and the other cells will be empty.

FYI. I want to remove text where the cells containing grey, red and blue text etc.

Thanks for any help provided.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.