View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
steve steve is offline
external usenet poster
 
Posts: 576
Default 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