Filter - VBA MAcro

[geliedee]

Hi All,

I saw this file that will filter based on the given criteria. Its completely working with text however, i have to filter it by numbers. When i remove the ' in the numbers then i encountered errors.

Can someone help me how to address it in the code below? The criteria that i will be using will be numbers...

Please Login or Register  to view this content.

[apo]

Try making it so all the values in your arrays are 'strings'..

Check the value of the vCrit array in your Locals window with your existing code and then check it when you apply the code i just gave you..

Change this:

Please Login or Register  to view this content.

To this:

Please Login or Register  to view this content.

The fact that i used Chr(34) is inconsequential.. you could use any delimiter... like:

Please Login or Register  to view this content.

[geliedee]

Hi Apo,

I have changed the code but only the first criteria in the lists sheet is shown. The second criteria is not included in the filter evern though it exist.

Attached is the file.

[AB33]

I do not think filter works well with numbers as you have already find out yourself. Possible solution is to copy the column you want to filter in to separate column and change this column in to text, filter it and then delete this temp column.

[Alf]

If you wish to filter for numbers you need to change this line

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

then you can filter for numbers.

Alf

[apo]

You have not removed your autofilter line of code.. so it is getting the correct result with the 2 lines of code i gave you and then your original autofilter line is then getting applied.

Always handy to step through your code with F8 to see how it works.

This line needs to be removed:

Please Login or Register  to view this content.

[geliedee]

Hello, apo. I Still cant get it working even though i have removed it.

[apo]

ok.. here is the code..

I have added it into your Original Workbook you attached.. works here..

Please Login or Register  to view this content.

[geliedee]

Thanks Apo!