This is a little piece of my code:
MsgBox ("Before Advanced filter" & Worksheets("Datos").AutoFilterMode)
Range("'Coaching.xls'!Datos").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("'Coaching.xls'!Crit_Filtro"), _
CopyToRange:=Selection, Unique:=True
MsgBox ("After Advanced filter" & Worksheets("Datos").AutoFilterMode)
Before advanced filter, autofilter mode of worksheet "Datos" is true; after advanced filter is false.
Note: range "Datos" is a named range in Worksheet "Datos"; Criteria range "Crit_filtro" is in another worksheet (different to "Datos") and "Copy to" range is in another worksheet (different to "Datos" and to Criteria Range's worksheet):this means that there are three different worksheets that participate in my advanced filter.
Why is advanced filter changing my source data worksheet autofilter mode?.
Note: executing my advanced filter out of VBA (with Excel's menu), the autofilter mode oh worksheets("Datos") doesn't change.
Thanks a lot for your help.
MsgBox ("Before Advanced filter" & Worksheets("Datos").AutoFilterMode)
Range("'Coaching.xls'!Datos").AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Range("'Coaching.xls'!Crit_Filtro"), _
CopyToRange:=Selection, Unique:=True
MsgBox ("After Advanced filter" & Worksheets("Datos").AutoFilterMode)
Before advanced filter, autofilter mode of worksheet "Datos" is true; after advanced filter is false.
Note: range "Datos" is a named range in Worksheet "Datos"; Criteria range "Crit_filtro" is in another worksheet (different to "Datos") and "Copy to" range is in another worksheet (different to "Datos" and to Criteria Range's worksheet):this means that there are three different worksheets that participate in my advanced filter.
Why is advanced filter changing my source data worksheet autofilter mode?.
Note: executing my advanced filter out of VBA (with Excel's menu), the autofilter mode oh worksheets("Datos") doesn't change.
Thanks a lot for your help.