Pasting from one cell to another & keeping it's color

jolivanes · #1 01-10-2018, 09:58 PM

Simmilar what the "traininglady" alluded to.

Code:

Sub Try()
 Range("A1").Copy
 Range("A3").PasteSpecial Paste:=xlPasteAll
End Sub

AFAIK, cut instead of copy does not work. We might hear from someone that proves this idea wrong though.
If it is true, you might have to go back and delete after the pastespecial is done.

jolivanes · #2 01-14-2018, 01:34 PM

@lostsoul62
Did any of the suggestions work? It's always gratifying to know.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Keeping a cell from being changed	melvin1942	Excel	2	07-12-2017 01:11 PM
Remove white text background (keeping the font color and page color intact	cc3125	Word	1	10-26-2015 06:44 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting	hanvyj	Excel Programming	0	08-28-2015 01:15 AM
Keeping Font Color Changes After Switching Slides	Kazumi7677	PowerPoint	0	10-15-2014 08:29 PM
Keeping an absolute reference in a cell	bremen22	Excel	7	01-16-2014 11:06 AM