Filter data type mismatch? Filter column of numbers from criteria on 2nd sheet w/ wildcard

I have this line where the input for E8 can be blank or contain a number

blank cell
0
0.34
23.43
234.43
234.23423

etc

I have this code for a filter

Sheets("sheet2").Range("A:A").AutoFilter Field:=2, Criteria1:="*" & Sheets("sheet1").Range("E8") & "*"

Which searches Field 10 which is data stored as numbers
The result is always a 0 return, this must be a data type mismatch?
Testfilter.xlsb

hi sdl2, may be it should be

Please Login or Register  to view this content.