Lone Wolf Development Forums - View Single Post

Ash Nazg · 11:52 AM

To preserve the multiple text formatting in the cell, you need to use the PasteSpecial method of the destination Range object, and you need to use the xlPasteAllUsingSourceTheme XLPasteType.

Code:

mySourceRange.Copy
myDestinationRange.PasteSpecial Paste:=xlPasteAllUsingSourceTheme

I hope that helps,
~ Ash

Ash Nazg Junior Member Join Date: Apr 2018 Posts: 15 February 27th, 2019, 08:11 PM	To preserve the multiple text formatting in the cell, you need to use the PasteSpecial method of the destination Range object, and you need to use the xlPasteAllUsingSourceTheme XLPasteType. Code: mySourceRange.Copy myDestinationRange.PasteSpecial Paste:=xlPasteAllUsingSourceTheme I hope that helps, ~ Ash Last edited by Ash Nazg; February 28th, 2019 at 11:52 AM.
#4