Autofilter searching only for not equal values

[Szwadron6]

Hi!

I wrote a simple code in order to:

1) create AutoFilter on the existed table
2) show only records than in the third column have value different than #N/D!"

I have something like this:

Please Login or Register  to view this content.

Unfourtunately it does not work and records does not show up. Could you please take a look at the code and indicate the error?

Thanks in advance!

[TMS]

Works for me.

Suggest you post a sample workbook with some typical data.

[Szwadron6]

Example attached. I am referring this to module 'KIA' in VBA editor. The filter is conducted but does not show the right records (only does that are not equal to #N/D!

[TMS]

Please Login or Register  to view this content.

works for me.

The error code shows up as #N/A in my copy of Excel, not #N/D! ... note that there is no exclamation mark ( ! )

[Szwadron6]

OK. I see, with #N/A works for me as well.

Thank you!

[TMS]

You're welcome. Thanks for the rep.