littlepete
Well-known Member
- Joined
- Mar 26, 2015
- Messages
- 503
- Office Version
- 365
- Platform
- Windows
hello
the result of my autofilter that filters a keyword in column CJ (88th column) is always 88 ...
why is he not filtering on the keyword???
the result of my autofilter that filters a keyword in column CJ (88th column) is always 88 ...
why is he not filtering on the keyword???
VBA Code:
Sub familiefilter() ' ---------------------------------------------------------------------------------- ctrl - i
Application.ScreenUpdating = False
Dim dezerij As Long
dezerij = ActiveCell.Row
ActiveSheet.Range("A4:cj379").AutoFilter Field:=88, Criteria1:=Range("cj" & dezerij).Value, Operator:=xlAnd
Application.ScreenUpdating = True
tooneersterij
End Sub