excel vba help request - hide columns based on cell value in selected worksheets

[rogeryung]

Hello, I can't seem figure out how to hide columns in a range based on a cell value in an array of sheets. I can do it for one sheet, but can't figure out how to loop it to the others.

I have 20 sheets in a workbook, 8 of those are are identical, but different data. I want to be able to hide all columns in those sheets that don't have the value "2020" in row 4 of columns G:CL

I was able to get it to run with one sheet, but struggling to make it loop to the next 7 sheets.

Can anyone help?

Thanks
Roger