View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Copying Color-Coded Text and Pasting it in that format to Word

What changes have you made between the past and present?

Could be a clue there?

These are the steps I would take.

SHIFT + EditCopy PictureAs shown on screenas pictureOK

Open a Word doc and EditPaste SpecialEnhanced Metafile


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 14:52:00 -0800, Hope 2002 <Hope
wrote:

How do I copy color-coded texts from EXCEL to WORD in the same format?

In the past, I used "Paste Specials" then "Picture (Enhanced Metafile)" and
I could paste all color-coded texts from EXCEL in the same format into WORD.
However, recently when I copy color-coded texts from EXCEL to WORD, they
simply appear Black/White.

Please help!!