I have some table build up from different formulas and so on.

Final result is some huge sheet filled with columns and lots of rows showing just True or False.

I'd like to know how i could hide all columns that are all their values True, so i can just end up with just the False items.

For the rows is easy because i just applied a filter. But can't seem to find a way to hide the column.

Was thinking about maybe making a sum for the whole column, and if its = 0, then hide column.

Something like this, but obviously giving error in the countif line:

Code:

```
.Range("B2").Formula = "=IFERROR(INDEX('Sheet1'!AB:AB,$A2)='Sheet2'!Q2,""NF"")"
.Range("B2").AutoFill Range("B2:B" & Range("A" & Rows.Count).End(xlUp).Row)
.Range("B2").Select
.Range(Selection, Selection.End(xlDown)).Select
.Selection.Offset(1, 0).Formula = "=COUNTIF(B2:B & LastRow1,FALSE)" <- LastRow1 been declared earlier
If Range("B2").End(xlDown) = 0 Then
Range("B2").EntireColumn.Hidden = True
End If
```

thanks in advance!