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

lostsoul62 · #1 01-04-2018, 07:51 AM

Is there a way to cut data from one cell and paste it into another cell and keep the color you gave it instead of it turning black?

Logit · #2 01-04-2018, 09:47 AM

https://stackoverflow.com/questions/...another-in-exc

thetraininglady · #3 01-09-2018, 08:29 PM

Generally when you copy & paste it should keep the original formatting.
If it isn't and is making the text go back to black then you can use the Paste Special option and choose the Keep Source Formatting option.

jolivanes · #4 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 · #5 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