vba autofilter not working for numbers

[rossg]

this code works when I look up a text field but I need it to look up from a field of numbers


so if I have 2 columns 1 is a 4 digit product number the second is the product name, if range A1:A3 looks up product names it works but if I try to do the same for the product code it doesn't (yes I changed the auto filter columns to the relevant field)

Please Login or Register  to view this content.

**EDIT**
managed to find solution that works, code for anyone interested, added in split & join. seems to make VBA recognise the numbers as text or something...

Please Login or Register  to view this content.