title: Show/Hide column based on Dropdown selection in Excel
body: <p>I am trying to show a hidden column based on an option of my dropdown. For a single row it works fine but when I want to extend my Range for 10 rows</p>
  
  <p><code>If Range("$CF$5: $CF$15") = "Others" Then</code></p>
  
  <p>Tt displays a <code>Runtime error 13.</code></p>
  
  <p>Below is my code. Thanks for helping me out.</p>
  
  <pre><code>If Range("$CF$5") = "Others" Then
      ActiveSheet.Columns("CG").EntireColumn.Hidden = False
  Else
      ActiveSheet.Columns("CG").EntireColumn.Hidden = True
  End If 
  </code></pre>