title: VBA to select columns by true/false condition
body: <p>EDIT:
  Both of the codes below are nearly perfect, but ultimately had the same issue. B1 and D1:E1 are properly grouped, but for some reason, the entire range of data, A1:E1 is also grouped. B1 and D1:E1 then function as subgroups, which is not ideal.</p>
  
  <pre><code>    |   A    |   B    |   C   |   D   |   E   |
  -----------------------------------------------
   1  |  TRUE  |  FALSE |  TRUE | FALSE | FALSE |
   2  |        |        |       |       |       |
   3  |        |        |       |       |       |
  </code></pre>
  
  <p>In my set of data, starting with B1, the first row has TRUE or FALSE. Ultimately, I am trying to group all columns that have FALSE. This is the code I have so far. The code runs, but it doesn't do anything. Any suggestions</p>
  
  <pre><code>Option Explicit
  
  Sub hideColumns()
  
  Dim falseColumnRange As Range
  Dim grp2 As Range
  
  Set falseColumnRange = GetFalseColumnRange(Range("A1", Cells(1, Columns.Count).End(xlToLeft).Offset(1)))
  
  If Not falseColumnRange Is Nothing Then
      For Each grp2 In falseColumnRange.Areas 
          grp2.Columns.Group
      Next
  End If
  
  End Sub
  
  Function GetFalseColumnRange(rng2 As Range) As Range
      Dim ColumnRange As Range
      Dim Cell As Object
      For Each Cell In rng2
        If Cell.Value = False Then
          Set ColumnRange = Range(Cell.Address)
      Else
      End If
  Next
  End Function
  </code></pre>