Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISBLANK function not working when cell is blank dut to function re | Excel Discussion (Misc queries) | |||
ISBLANK and OR Function | Excel Worksheet Functions | |||
ISBLANK FUNCTION | Excel Worksheet Functions | |||
ISBLANK() function | New Users to Excel | |||
isblank function | Excel Worksheet Functions |