"RG III" wrote in message


Try PasteSpecial HTML


Well, that does paste rich text into multiple Excel cells. Now I'm stuck
trying to figure out how to copy the rich text from an Excel cell back
into the clipboard in it's original rich text form.

Do you have any ideas?

-Robert


Nothing to do. By default when you copy from in Excel it copies to the
clipboard in a variety of 'clipboard formats' in including rich text and
HTML. There are different options for copying graphics.

If pasting back into Word could use paste-special rich-text (n/a in Excel)
but theme colours will get pasted as RGB's not necessarily the same. Also
the L/R margins will adjust to the cell width but easy enough to adjust. But
try pastespecial HTML again in Word. In other apps paste will get from the
clipboard in the app's default format.

Peter T