Auto filter search VBA

[Fean]

Hi,

I need to autofilter (basically search) on 2 criteria's.
Somehow the second criteria shows me no data whilst data is present!

Basically I have lists lots of accounts
441000
441001
421000
431999
etc etc

Now i want to see the accounts that begins with 42 (42xxxx)
Manually you can type 42* and Excel automatically selects the accounts for you.

In VB the first critieria works but i can get the account 42xxx be shown, its shows blank, whilst there are clearly numbers

?

Please Login or Register  to view this content.

[Bernie Deitrick]

If you are using numbers as the account number and not strings that look like numbers, then you need a number filter:

Please Login or Register  to view this content.

[Fean]

If you are using numbers as the account number and not strings that look like numbers, then you need a number filter:

Please Login or Register  to view this content.

ah that does makes sense actually.. it works!

Thanks for the reply.