| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to copy content AND formating with vba
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to copy content AND formating with vba
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically Copy content of a cell | Excel Discussion (Misc queries) | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| copy cell content only | Excel Programming | |||
| copy content of 1 sheet to another one. | Excel Programming | |||
| Cell to follow content AND/OR formating of another cell | Excel Discussion (Misc queries) | |||
Linear Mode
