I've made a macro so that when I enter a number in a textbox1 and textbox2 it finds all of the values between them (say 1 to 15)
but i cant seem to get the macro to work, could someone please assist me on this please, thankyou.
heres the macro i have so far
Sub Search_sale1(X As String)
Selection.AutoFilter Field:=3, Criteria1:=">X", Operator:=xlAnd
End Sub
Sub Search_sale2(y As String)
Selection.AutoFilter Field:=3, Criteria1:="<y", Operator:=xlAnd
End Sub
but i cant seem to get the macro to work, could someone please assist me on this please, thankyou.
heres the macro i have so far
Sub Search_sale1(X As String)
Selection.AutoFilter Field:=3, Criteria1:=">X", Operator:=xlAnd
End Sub
Sub Search_sale2(y As String)
Selection.AutoFilter Field:=3, Criteria1:="<y", Operator:=xlAnd
End Sub