If cell is not empty - insert formula to another cell

Guys,

I've got an excel sheet with a dropdown list (list of companies).

If I choose an item from drop down list, a macro is executed. The macro inserts vlookup formula to the range of cells (Range is D7:D300).

What I would like to achieve, is to not to run the macro if there is nothing in the cells from B7:B300 (nothing to vlookup for).

My current code looks like this:

Please Login or Register  to view this content.

And the macros:

Please Login or Register  to view this content.

Currently, if I input 10 values to look for in another sheet, and I run the macro (select company from drop down list), it provides me with the result for the 10 values and inputs an error to the rest 290 cells. I would like to avoid that.

Cheers
Deric

Thank you guys for your answers. I have also found another solution that works:

Please Login or Register  to view this content.