I have created a table in which I want to make a filter to indicate less than or equal to the number in textbox1 + průměr and maximum
i got it but it doesn't work for me :/
I have this so far:
ActiveSheet.Range("$B$31:$G$38").AutoFilter Field:=1, Operator:=xlOr, _
Criteria2:="<=" & TextBox1.Value, Criteria1:=Array("maximum", "průměr")
i got it but it doesn't work for me :/
I have this so far:
ActiveSheet.Range("$B$31:$G$38").AutoFilter Field:=1, Operator:=xlOr, _
Criteria2:="<=" & TextBox1.Value, Criteria1:=Array("maximum", "průměr")