Macro to hide columns if Header Name contains certain Character or Sign or Number

[sandubandu]

I have a worksheet with info in columns A2:IF2, For this data I need a macro that will look for the number "20" (for example, I have following headers in the data "TTL-20 SLS_QTY", "TTL-20 SLS_VAL" that needs to be hide) OR "YTD ACH%" in the column header and if it's there to then hide that particular column and move on and check the next. (NOTE: Column headers is in the 2nd row of the sheet)

I am struggling to find VBA to do this for me. I've been researching and trying different things for hours without success. Can anyone help? Thank you.

I have attached the file with headers for your reference.

Thank you in advance.

[nankw83]

Hi sandubandu,

Try below code ...

Please Login or Register  to view this content.

[sandubandu]

Its workng fine ! thanks a lot !

[nankw83]

Glad to help & thanks for the added Rep.

If that takes care of your original question, please take a moment & mark the thread as [SOLVED] from the Thread Tools above your first post