Thanks, but I'm looking for an If Statement that would allow a button to
toggle the filter on/off.

"Gord Dibben" wrote:

Dave

ToolsMacroRecord New Macro.

Record yourself while doing the above.


Gord Dibben MS Excel MVP

On Mon, 28 Aug 2006 13:12:01 -0700, Dave wrote:

I'd like to display all of a list -or- only records with blank cells in the
8th column.
What code could I assign to a button that would toggle an autofilter?
Thank you.