If autofilter is on, then..

[Darin Kramer]

Guys,

My Macro needs to autofilter on row 2.
Problem is I need to tell Excel to look whether there currently is an
existing autofilter on or not. (My code below says selction.autofilter -
ie if there is NO autofilter it correctly turns Autofilter on and works
fine, BUT sometimes there is an existing autofilter turned on, so all
the code does is turn the existing autofilter off, ie it does nothing.

Ideas...?

Thanks
D

sub filter
'turn autofilter on
ActiveSheet.Select
Rows("2:2").Select
Selection.AutoFilter
Selection.AutoFilter Field:=4, Criteria1:="ASPAC"
Range("c3").Select

End sub

 

[Dave Peterson]

If you're going to add the autofilter arrows, you can remove them first:

activesheet.autofiltermode = false

It won't hurt if there is no filter applied, too.

Then just apply it where you want.

 

[Darin Kramer]

Thanks Dave - works perfectly