title: Hiding various rows based on 10+ options on drop down menu
body: <p>I have a file that pulls data into a &quot;summary&quot; page. I want to be able to hide certain rows based off cell &quot;C4&quot;s input. Cell C4 has a drop down menu that chooses multiple different product info. For example the first input on the C4 Dropdown has info from row 8-32. The others sometimes only have info from rows 8-12, 8-17, 8-24, etc.</p>
  <p>Currently my code is this...
  Private Sub Worksheet_Change(ByVal Target As Range)</p>
  <pre><code>If Not Intersect(Range(&quot;C4&quot;), Target) Is Nothing And Target.Cells.Count = 1 Then
      Rows(&quot;12:31&quot;).Hidden = False
      
      Select Case Target.Value
          Case &quot;Transaction Mail&quot;, &quot;PPC Material Handling&quot;
          Rows(&quot;12:31&quot;).Hidden = False
          Case &quot;Parcels&quot;
              Rows(&quot;27:31&quot;).Hidden = True
          Case &quot;VEO&quot;, &quot;Packets&quot;, &quot;PIF Packets&quot;, &quot;Admail&quot;
              Rows(&quot;17:31&quot;).Hidden = True
          Case &quot;PIF Material Handling&quot;, &quot;IRU&quot;, &quot;RVU&quot;, &quot;PPC Others&quot;
              Rows(&quot;12:31&quot;).Hidden = True
                        
          Case Else
        
         
         
      End Select
  End If
  </code></pre>
  <p>End Sub</p>
  <p>For some reason, this code will unhide everything for &quot;Transaction mail&quot; and hide the proper rows for &quot;VEO&quot; which is perfect, but every other variable that is inputted into the C4 cell, doesn't take.</p>
  <p>Am I only limited to 2 variables? Should I be making multiple macros and have 1 macro basically activate them based off cell C4?</p>