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

*** Sent via Developersdex http://www.developersdex.com ***