Empty cells stops macros work

Hello few days ago I receieved help from people here and I am very thankful for that. It was about writing a macro which help me a lot with getting info from a database and display it when two circumstances occur. But I have a strange problem.

It is about numbers and the macro finds numbers everything is ok, but when is emty cell or false result the macto can not continue. The macro stops and a bug message occur.

Is there a solution? My english is poor enough to be difficult for me to explain my self correctly and this is why I attached the file I use.

In the sheet one I paste every day a different type of information and I have to cut every empty cell for having a working macro, but somedays this means more than 1000 empty rows.

The second sheet is the database from where the macro is taking info.

Thank you in advance