how to copy content AND formating with vba

  • Thread starter Thread starter T. S.
  • Start date Start date
T

T. S.

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a Picture From Cell Comment 0
Excel VBA - Problem with Closing Print Preview 0
Compare font colors 6
Excel VBA 1
CONCATENATE preserving original formating 3
VBA Conditional formating for specific text in several columns 1
Excel 2010. How to copy chart format to all charts in sheet 2
Conditional formatting with vba 3

Back
Top