By using you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

Become an Σxpert at Σ


Standard VBA/Excel (15 of 1182)

(Clear Filter = *Filter*)

Filtering and visible rows
GetNextRow - filtering udf
Selection.autofilter = turns off filter
range(...).Autofilter Field:=1, criteria1:="=" & sValue, Operator:=xlAnd = recorded sets a filter
Cells.autofilter field=lCol, Criteria1:="=*IBM*", Operate:=xlOr, Criteria2:="IBOR*"
Remove filtered data but keep filters
ActiveWorkbook.Worksheets("....").Autofilter.sort.sortfileds.clear ' clears a filters sorting ' recorded
ActiveSheet.PivotTables("pt1").PivotFields("coper_id").PivotFilters.Add Type:=xlTopCount, DataFiled:=... ' recorded
Public gsFilters() As Filter_fields 'Filter fields is a udt
Filter Problems copying moving...
Date filtering problem due to 12/1/2021 vs. 12/01/2021 vs. 7/2/21 vs. 07/02/2021 vs. 7/02/2021
CountFiles(sDir, sFilter)
11/12/14 Filter