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
Bookmarks