Trying to convert a horizontal filter from hiding columns that contain to hiding all other

Hi
I have this macro that enables me to hide the colums that contain the value in cell B3 in row 3
But what I need is for it to do the opposite, to hide all columns that do NOT contain the value in cell B3

Thanks

Please Login or Register  to view this content.

Change the ">= 1" on the 4th line to "= 0"

Hope this helps.

Pete

Thanks,
that worked perfect
Now I'm running into another issue, the filter is keeping cells that contain what I put in the reference cell, I wan't it to keep only the columns that contain EXACTLY what is written in the reference cell

I appreciate the help

Well, you'll probably need to change that 4th line to this:

Please Login or Register  to view this content.

Hope this helps.

Pete

Hey thanks for the help but that didn't work, now it filters everything out

Please Login or Register  to view this content.

Well, the values are not exactly the same then, so it is doing what you asked for.

Pete

Well no, it's not even keeping what is in the reference cell B3, even when typed exactly the same

Thanks for the help

Mr. Pete,

I sent you PM about horizontal filtering I obtained from another website. Please PM back with your email so I can send you my file. I hope you can help me thanks so much.

@dusk

You should not post your own question in another member's thread - read the Forum Rules. Instead, you should start your own thread. Besides, I'm going on holiday tomorrow, so I won't be able to help you.

Pete

Ok thank you for not helping u take care (-;