search text hide column

[eliozo]

hello!
Need your help in this:
I need to click a button, and once clicked tell me to search a name in row 2.

After clicking yes, the columns that doesn't contain this text will be hidden. and the columns that will contain it (or a part of it) will be shown.

Thank you

 

[Peter_SSs]

Merged cells and vba often do not go well together: Discussion

 

[davesexcel]

This also explains why my code did not work for you.

 

[Peter_SSs]

This also explains why my code did not work for you.

Partly. Your code would only ever hide at most one column, even if there were three columns that contained the given text. The OP wants to hide all columns that contain the given text. Refer to the details in post 4.