Question about keeping cell properties when doing a Vlookup

[macklo54]

I have a data sheet that I want to run a VLookup on. However, each cell on that data sheet has unique properties, such as bolded words or different sized fonts. When I complete the Vlookup these properties are lost.

Is there any way to keep these properties after completing a Vlookup???

 

[macklo54]

Re: Question about keeping cell properties when doing a Vloo

thanks a bunch parry...it worked to perfection...you are a vba god