I have been asked to create a macro using a command button that will select a specific colour of text For example dark red colour index 9.
What this macro has to to is copy this colour text from the other colour texts in the selected range and then paste it onto another worksheet.
I can record a macro that copies and pastes a range of text with no problem. I just can not make it select my specific text colour.
Thanks for any help you can give me.