I'm using a ListBox linked to a cell (KQ5) to hide/unhide columns using this macro:
Private Sub ListBox2_Click()
  Dim cel As Range, Utilities As Range
  Dim s As String
    Application.ScreenUpdating = False
  Set Utilities = Sheets("Q1Sales").Range("S5:KO5")
  s = ListBox2.Value
  If s = "" Then
    Utilities.EntireColumn.Hidden = False
  Else
    For Each cel In Utilities
      cel.EntireColumn.Hidden = Not cel.Value = s
    Next cel
    Application.ScreenUpdating = True
  End If
  Utilities.Parent.Activate
End Sub
My spreadsheet is about 250 columns and 150 rows. This macro works but it is unbearably slow, like 10-15 seconds. What can I do to increase its speed down to 1-2 seconds? Thanks. David