Posted 8 September 2017, 12:55 pm EST
We have a detail process that processes about 1200 text files and accumulates summarized information which is dumped to a spread. Certain information is highlighted using various colors.
If I click in the upper left hand corner of the spread, I can select it all and copy it to Excel but I lose all of the background colors, some Row.BackColor and some Cell.BackColor. Is there a way to copy the information from the clipboard and keep the back ground colors? Thanks!