Autofilter number with wildcard return blank value

Hi,

I have below code to seach my data in another sheet. It works fine when the search is for the column containing text but when I am using the same code to the column containing only number, this returns me blank value and search for nothing. Is there anything wrong here? Please help.
Example number 1122334455 where I allow search with a part of number e.g. *2233*

Please Login or Register  to view this content.

It is because the search criteria takes a string, not a number. You can convert the number in to a string.

Mynumber= cstr(ThisWorkbook.Sheets("Sheet1").Range("M15").Value) and
use this Mynumber as a criteria.

HI AB33,

Thank you for your reply. I have set Mynumber as you said, still I get the same result.

Please Login or Register  to view this content.

Sorry! I was meant to be the search column. You have a search item as a string, but the searched column is still a number.
I normally format the search column as a text first, then filter and convert back the column in to numbers.

Hi jindon,

This work so great. Thank you very much

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.