Search range

[Flex13CMP]

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:=" End Sub

[Tom Schreiner]

Hope this helps you...

Where TextBox1.Text = "1"
and TextBox1.Text = "15"

Sub SearchSale(FromNum As String, ToNum As String)

Columns("A").AutoFilter Field:=3, Criteria1:=">=" & FromNum, Operator:=xlAnd, _

    Criteria2:="<=" & ToNum

End Sub

Tom