ISBLANK function
 

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

ISBLANK function
 

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

--
sb
"keyt" wrote in message
...
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

ISBLANK function
 

Try:

Name Date
TOM =

(just the equal sign under Date)
--
Dianne

In ,
keyt typed:
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