title: Unhide rows in Excel with VBA
body: <p>I'm trying to use the following code in Excel, but it is not working. Cell AE25 refers to a cell using data validation to pull the numbers 1-8 from a list.</p>
  
  <pre><code>Select Case Range("AE25").Value
     Case 1
        Range("A26:A28").EntireRow.Hidden = False
     Case 2
        Range("A26:A29").EntireRow.Hidden = False
     Case 3
        Range("A26:A30").EntireRow.Hidden = False
     Case 4
        Range("A26:A31").EntireRow.Hidden = False
     Case 5
        Range("A26:A32").EntireRow.Hidden = False
     Case 6
        Range("A26:A33").EntireRow.Hidden = False
     Case 7
        Range("A26:A34").EntireRow.Hidden = False
     Case 8
        Range("A26:A35").EntireRow.Hidden = False
  End Select
  </code></pre>
  
  <p>Any help would be appreciated.</p>