Vlookup macro

[BarneyB]

Hi, I'm Barney and a novice at VBA. I have created a macro to open a workbook from another workbook and do a vlookup against the data in the source workbook. I then wanted to highlight the cells in the in the workbook that I'm doing the vlookup from, and to unhighlight any empty cells. I did this all without code using the macro recorder so that I could then study the code and learn something.

Couple of questions. My buddy does this stuff with code and his code is very elegant compared to what you get when you record a macro and then view the code. Here is the code:

Please Login or Register  to view this content.

Questions are:

1. Is there a simpler way to do this so that it is more economical in code simpler to understand?

2. How do I make the unpopulated cells loose the color format?

I hope this makes sense!

Thanks for any help!


Barney

[Leith Ross]

Hello BarneyB,

Here is the revised macro. Much easier to read and understand.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[BarneyB]

A belated thank you for the help!