Carry Formatting

axisjon · Mar 20th, 2002, 10:57 AM

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. · Mar 20th, 2002, 11:26 AM

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

Al Chara · Mar 20th, 2002, 11:27 AM

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.

Mar 20th, 2002, 11:27 AM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	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. __________________ Kind regards, Al Chara

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 20th, 2002, 10:57 AM	#1
axisjon New Member Join Date: Mar 2002 Location: Midwest, USA Posts: 9	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!!!

Mar 20th, 2002, 11:26 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	VLOOKUP returns only values, and not their formatting as it appears in the lookup table.