remove one item from Filter

[nazimscr]

Hi All,

I want to remove one item from the fiter, let say "item4". I tried to record a macro, and this was the code which i got.

Please Login or Register  to view this content.

But the problem with this code is it selects item which needs to be shown. In other tables i will have hundreds of items, so i will not be able to use same code there. Is there way like select all items and then unselect one item (in this case item4).

I would really appreciate your help.
Nazim

[JBeaucaire]

Maybe:

Please Login or Register  to view this content.

[johnjohns]

Instead of directly un-selecting one item, I used custom autofilter and chose where headding01 doesnot equal to item4 while recording the macro. Here is the result

Please Login or Register  to view this content.

This should work

rgds

johnjohns

[nazimscr]

Thanks it really works