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
|