How to filter specific values entered by user in array

[shardin]

I have a table with diferent values. The user has to enter in an inputbox what values must be filtered (several values).

This is the macro:

Please Login or Register  to view this content.

This macro does not work, as the output is empty. I have tried several imputs such as "430, 431, 432" or "430", "431", "432". I have also changed "" by ', but no result either.

Does anybody know what the format is or how can I solve the problem?

[mehmetcik]

You Have programmed excel to look at column 12. Which column did you intend to look at?

[AlphaFrog]

Try this and make the entry like this; 430, 431, 432

Please Login or Register  to view this content.

[shardin]

Thanks Alpha, very much appreciated.