Skip the blank cells

Hello everyone,

I've built a worksheet that stores a lot of information, description about itens mostly but because it has hundred of items, it also has a lot of blank description cells.

It something like:


IPAD: | Wi-fi |64gb | 1234g |Blank |Blank |Blank |Blank |Blank |Blank |Blank | Power Cable |



So, in another sheet I have some PROCV that search for the items (including the blank cells) and a macro that delete blank cells, so I can print it all in one page.

But as time goes by the amount of information is getting huge and the macro is starting to crash a little...


So, does anyone know a way to search for those items ignoring the blank cells?



Thanks in advance for the help;