View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Toggle Autofilter

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.