Why cant i pass an integer to the filter search criteria???????????

[JamesGoulding85]

Im using this code:

Please Login or Register  to view this content.

the seach criteria is either a string or a number. i want to beable to search for the criteria any where within the cells. The string works fine, but when i use a number it wont work???

Ive tried so many variations and even set it as just a straight number and it still wont work!!!!

help appreciated!

[JamesGoulding85]

Ok so ive removed the Isnumeric section and that applies the filter to a column that contains strings, wether you pass a number or a strinf.

How ever when i apply a filter with a number to a column containg number it still wont work. ie filter column with numbers containing 20.

Ive realised that if i put equals 20 it will work, but wont relate contains 20 to a cell with 20 in!!


hope that makes sense! please help

[Richard Buttrey]

Hi,

This would be easier if we had the workbook in question and some specific examples to test.
However in the absence of a workbook don't forget that you can always convert a number to be a string by wrapping it in a Cstr(MyNumber). And of course vice versa, convert a string to a number with Clng(MyNumber). Using Cstr() on a string of course leaves the string as it is.

[JamesGoulding85]

Richard,

it works when im searching for "20" within a string, however when searching for "20" within a cell containg a number it doesnt work! ie it wont filter all the 20's or numbers like 200 or 220???

Thanks for the help

[romperstomper]

It shouldn't work manually either if your data are actual numbers. 'Contains' only works on text data.