View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Muth69 Muth69 is offline
external usenet poster
 
Posts: 1
Default remove autofilter results with a macro

I can't seem to find anything similar to this. I'm trying to setup a macro
that will unfilter the sheet if the autofilter has been engaged. I can get
it to work as long as at least 1 column has been autofiltered, but if none
has been I get a run time error 1004. So then I tired a If then, but it
keeps hanging on part of the field. Thanks for your help.