AutoFilter during macro issue

[jadamek02]

I am using Microsoft Excel 2010. I have a macro that is not working they way I need it to work. I will try to explain it as best as I can. Any help will be appreciated.

I have three columns with a couple thousand rows. I would like an autofilter to exclude(filter out) "0" and "(Blanks)" of the first column. I have recorded this event in the macro recorder and it works, but it is working backwards.

Please Login or Register  to view this content.

Instead of filtering out "0" and "(Blanks)", it is filtering in all others. This will be problematic because each time I run this event, the first column will contain different figures. What can I write that will filter out options instead of filtering in the options in my example?

[Norie]

Try this.

Please Login or Register  to view this content.

[jadamek02]

Norie, thanks for the reply. Is this going to filter out "<>" and "<>0"? It looks to me like it is filtering them in and everything else out. I want the opposite of that.

[Norie]

Did you try the code?

It filters for everything not equal (<>) to a blank cell or 0.

[jadamek02]

Yes, it works like you said. Thank you.