title: Excel Autohide/Unhide rows based on Cell Value
body: <p>I have an excel form that i wan to hide rows 43 to 49 if the value in cell B22 is equal to or greater than 25000.</p>
  
  <p>I have this code so far but it seems to just crash excel and i have to escape out of it.</p>
  
  <pre><code>Private Sub Worksheet_Calculate()
  
  Rows("43:49").EntireRow.Hidden = False
  Select Case Range("B22").Value
  Case Is &gt;= 25000
  Rows("43:49").EntireRow.Hidden = True
  Case Else
  Rows("43:49").Select
  Selection.EntireRow.Hidden = False
  
  End Select
  End Sub
  </code></pre>