title: Hide columns that have column headers with no data?
body: <p>I'm trying to hide columns that have no data in it, while keeping the ones with data showing even if there is only one item in the column. Here is the code I'm using:</p>
  
  <pre><code>Dim cl as Range
  
  For Each cl In Range("A2:U2")
      If cl.Value = "" Then
          cl.EntireColumn.Hidden = True
      Else
          cl.EntireColumn.Hidden = False
      End If
  Next cl
  </code></pre>
  
  <p>This works, however I do have it reading A2 to U2 and hides the columns, based on that row, including ones that do have information. Would I have to add something like xldown for it to read everything from that point to determine if it should hide the column? Much appreciated for the assistance!</p>