Excel 2007 : Vlookup! Keeping the format

[Gl1234]

Hi

I'm really need help with this. I have huge excel sheet that my company uses to input data data both text and numbers. Status report.

I'm using vlookup in one place and it picks up the text for report from following time period that the user chooses.

I need vlookup to bring the text to the report and keeping format of the text in place. No problem with spaces and lines. Bold text is the problem.

I know I have to use VBA - BUT HOW???

Thanks.

[mrice]

Can you provide an example because VBA code will need to know the postion of the cells that you want to work with.