Sub HideColumns()
Dim numEntite As String
numEntite = Range("B1").Value
For Each cell In ActiveSheet.Range("D4:BR4")
If cell.Value <> numEntite Then
Columns(cell.Column).Select
Selection.EntireColumn.Hidden = True
End If
Next cell
End Sub