ISBLANK function

[keyt]

What is the syntax for including ISBLANK in an advanced
filter?

The criteria should include showing all records that have
a blank field (column).

ie:

Name Date
TOM

 

[steve]

Keyt,

Got me stumped on ISBLANK.

BUT - you could do a GoTo Special and hide the selected
rows (do this for constants and than for formulas):

Columns("A:A").SpecialCells(xlCellTypeConstants, 23) _
.EntireRow.Hidden = True
Columns("A:A").SpecialCells(xlCellTypeFormulas, 23) _
.EntireRow.Hidden = True

 

[Dianne]

Try:

Name Date
TOM =

(just the equal sign under Date)