title: Why is a small Excel VBA Macro is running extremely slow
body: <p>I am writing a short macro to hide all customers that have no current sales for the current year. The YTD sales are in the K column (specifically K10-250). Those cells use a vlookup to pull data from another tab where we dump data. My question is why on earth would this macro take 10-15minutes to run? I have a similar macro on another spreadsheet that takes only 2-3 minutes for over 1,500 rows. I have already turned off screen updating. I can't think of anything else that would speed it up.</p>
  
  <pre><code>   Sub HideNoSlackers()
  '
  ' HideNoSlackers Macro
  '
  
  '
  Application.ScreenUpdating = False
  '
   Sheets("CONSOLIDATED DATA").Select
   Dim cell As Range
   For Each cell In Range("K10:K250")
     If cell.Value = 0 Then
       cell.EntireRow.Hidden = True
     Else
       cell.EntireRow.Hidden = False
     End If
   Next
  End Sub
  </code></pre>