Hi,

I'm trying to do a text filter that begins with the value of cell A1, which is an inputted value prompted from a myValue.

The problem is the filter is just coming up blank.

Can you help and advise where this is going wrong?


Range("A1").Select
Selection.NumberFormat = "@"
 myValue = InputBox("insert date DD/MM")
 Range("A1").Value = myValue
 ActiveSheet.Range("$A$3:$U$4887").AutoFilter Field:=17, Criteria1:="=myValue*", _
        Operator:=xlAnd