Skip the blank cells
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;
Re: Skip the blank cells
people with a sample workbook and people with a view of the current code
they would be the ones
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1