how to copy content AND formating with vba

's Computer Specifications

Hi there.
How do I copy the contents of cell a (contains text in several colors)
to cell B, so that colors/fonts etc are preserved?

Thanks in advance.

's Computer Specifications

Exmpl:

Sub cpy()
ActiveSheet.Range("A1").Copy ActiveSheet.Range("B1")
End Sub

If you don't want to copy everything, you have to use the paste special
method to specify exactly what you want entered in the receiving range.

"T. S." wrote:

> Hi there.
> How do I copy the contents of cell a (contains text in several colors)
> to cell B, so that colors/fonts etc are preserved?
>
> Thanks in advance.
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I copy ALL formating and setup?	AFD at FONO	Microsoft Excel Misc	5	26th Mar 2008 12:10 AM
copy comment content to cell content as data not as comment	=?Utf-8?B?TGlsYWNo?=	Microsoft Excel Misc	2	21st Jun 2007 12:28 PM
?? copy conditional formating	=?Utf-8?B?cm9iZXJ0IG1vcnJpcw==?=	Microsoft Access	1	7th May 2007 07:13 PM
Reference to content AND formating of target cell	0-0 Wai Wai ^-^	Microsoft Excel Discussion	3	8th Sep 2005 10:58 AM
Copy calendar formating only?	=?Utf-8?B?Qm9iYmk=?=	Microsoft Outlook Calendar	1	11th Mar 2005 01:29 PM