By using listi.net you agree to our
cookie policy
, We and our partners operate globally and use cookies, for multiple purposes
Close
listi.net
Filters
truncate tbl
|
Show whole table
A
B
C
D
E
F
G
H
I
J
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
This is good to teach prior to If
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)
A
B
C
D
E
F
G
H
I
J
Add 10 rows
CTRL
Alt
L
|
Add new col
CTRL
Alt
d
|
Copy Header
CTRL
Alt
H
Please enable JavaScript to view the
comments powered by Disqus.
blog comments powered by
Disqus