Hi Guys,

Just so you know - I managed to resolve it by adding following piece of code into the macro:

Columns("B:C").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
This searches for all empty cells in colums B and C of the data in the filter results and deletes entire row if an empty cell is found.

a bit of an overkill, but works...

Cheers,
Seler