Sub hide_columns()
Dim ws As Worksheet
Dim col As Long
Set ws = ThisWorkbook.Sheets("Sheet1") 'シート名を変更する場合はここを修正
'非表示にする列の見出しを格納する配列
Dim hide_columns() As String
hide_columns = Array("Column1", "Column2") '見出し名を変更する場合はここを修正
For col = 1 To ws.UsedRange.Columns.Count
If IsInArray(ws.Cells(1, col).Value, hide_columns) Then
ws.Columns(col).EntireColumn.Hidden = True
End If
Next col
End Sub
Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean
IsInArray = (UBound(Filter(arr, stringToBeFound)) > -1)
End Function