I am using paste special to copy text in a group of cells into a set of cells on another page.
This happens except that colored text pastes as black and white text. What change(s) do I have to make to paste the text color as well?

Thanks