"RG III" wrote in message

Suppose I open a Word document full of rich text with colors and bold text,
etcetera. Then I highlight everything with Ctrl-A and copy it into the
clipboard with Ctrl-C.

Now, can I paste this rich text into a spreadsheet cell or somewhere in an
Excel document and still retain all the rich text properties? If I have
rich text stored somewhere in an Excel file, I'd like to create a macro that
copies that rich text back into the clipboard. I know the command/functions
for copying data into the clipboard using VBA. I just don't know how to
store rich text in an Excel file.

Any ideas?

-Robert

--------------------------------------------------------------

Try PasteSpecial HTML

Peter T