Auto Filter Macro

[BenLightfoot]

Hi, I am having a little issue with an autofilter Macro I have set up.. I'm sure this is quite simple so if any one can help it would be much appreciated.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a Macro that filters various sheets on a name that a person selects on a control sheet. The Macro looks at that name then simply filters the sheets.. Now what If I don't want a filter to apply? What would the Macro lookup, you have to select something from the drop down box before continuing, I have tried putting in (Select All) as an option but the filter returns nothing. Below is the Macro.. And it is the "SectorFilter" range that has the persons name in.<o></o>
<o></o>

Selection.AutoFilter
Selection.AutoFilter Field:=1, Criteria1:=Range("SectorFilter"), Operator:=xlAnd<o></o>
<o></o>
Many thanks<o></o>
<o></o>
Ben<o></o>

 

[Weaver]

maybe something like

Selection.AutoFilter
if range("sectorfilter")<>"Select all" then
Selection.AutoFilter Field:=1, Criteria1:=Range("SectorFilter"), Operator:=xlAnd
end if

 

[Andrew Poulsom]

To turn off the AutoFilter:

Selection.Parent.AutoFilterMode = False

 

[BenLightfoot]

Thanks Guys! I have sorted it now.. I have just put a conditional IF in based on the filter..

I'm new to Macros so thank you for the advice.

Cheers

Ben