Answer the question
In order to leave comments, you need to log in
How does Selection.AutoFilter work?
There is an Excel sheet:
A | b | c | D ...
<table header>
numbers | Value# | empty | Surnames | ...
There is such a shitty macro code:
Sub Id_obj()
Sheets("Лист1").Select
Application.ScreenUpdating = False
Dim Balon As Integer
Balon = Sheets("Лист1").Range("CF6")
Select Case Balon
Case 1
Selection.AutoFilter Field:=1, Criteria1:="Значение1"
Selection.AutoFilter Field:=3, Criteria1:="<>"
Case 2
Selection.AutoFilter Field:=1, Criteria1:="Значение2"
Selection.AutoFilter Field:=3, Criteria1:="<>"
...
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question