Hi Guys,
Just so you know - I managed to resolve it by adding following piece of code into the macro:
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.![]()
Columns("B:C").Select Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
a bit of an overkill, but works...
Cheers,
Seler
Bookmarks