Carry Formatting

[axisjon]

I am using Vlookup to populate cells in one worksheet with 3 paragraphs from another.
All is good after I copy the column and past special as values, except 1 thing.
I lose the Bold Face format. Is there a way to retain the text format code?

Thanks!!!

 

[Mark W.]

VLOOKUP returns only values, and not their formatting as it appears in the lookup table.

 

[Al Chara]

Try the following code:

With Selection
.PasteSpecial Paste:=xlFormats
.PasteSpecial Paste:=xlValues
End With

This code will paste the formats and values of whatever is on the clipboard, into the cells that are selected.