Foolproof Advance Filter criteria - blank cells

This will hide all rows that have blank cells in C or D

Dim rng As Range

Set rng = Range(Cells(2, 3), Cells(Rows.Count, _
    4).End(xlUp)).SpecialCells(xlCellTypeBlanks)
rng.EntireRow.Hidden = True