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

listi.net

Filters

A	B
What is a filter	A way to hide rows
Filter actions	Turn on Clear standard conditions And/Or Not Contains Color 1 vs. 2 filters
Turn on Filters	'if no filters exist Range("A1").Select Selection.Autofilter
Turn off Filters
Clear Filters	On Error Resume Next Activesheet.ShowAllData
Loop through filtered data	lStart = GetNextRow()
Find last row with filters	FindLastRow
Filter problems	Date is a string
Subtotals	=subtotal(3,1:1)