VBA Hide unwanted columns on multiple sheets or a workbook

[usui]

Hi guys can anyone help me create a VBA code to hiding unwanted columns not needed, i want to enter the specific column header only that I want to remain on the sheets,

Sample: I want "Tea" (can be change anytime) to remain on all the sheets because this is a workbook, and the rest o the columns will be hidden so that only the Tea will remain
The search should only start on Column H, so meaning starting from column "H" all the columns aside from Tea will be hidden.


I hope someone can help me with this, and hoping to make it work on all the sheets in the workbook.

 

[My Aswer Is This]

only for active columns

Define active column

 

[usui]

Define active column

columns that has data?

 

[Fluff]

Duplicate to: Help VBA code!..Auto delete unwanted Columns

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.