Hide Columns Based on a Cell Value that DO NOT contain one of multiple values or wildcard.

Hello,

I’m a macro/VBA rookie and I’m trying to build a macro that hides or shows columns that don’t contain multiple values or partial text strings. I’ve found and modified code that will hide or show all columns that don’t contain one value, but I’m having trouble with using a wildcard or multiple criteria.
Here’s the code I’m trying to use. The “Or” command seems to be the problem.



Code:

Please Login or Register  to view this content.

I also tried using a wildcard but these did not work:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

In plain ‘ole English, I need the macro to hide all columns based on a cell value that don’t contain LABEL1, LABEL2, etc. (C-PRG and S-PRG in my code above.) I’d also need a macro that hides all columns based on a cell value that don’t contain a wildcard search, such as all columns whose cell reference does not contain *BEL* (I’m using BEL as an example since it is contain in the word LABEL.)
Can anyone help?

Thanks for the reply! I pasted this line in to replace mine but it still appears to hide all the columns, even the ones that contain PRG. Any advice?