ISBLANK function

  • Thread starter Thread starter keyt
  • Start date Start date
K

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
 
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
 
Back
Top