Hi

I'm trying to get the following to work;

VB Code:
  1. For x = 1 To 28
  2. For Each CheckBox(x) In sSheet
  3.     If Not CheckBox(x) = True Then
  4.         For i = 6 To Sheet3.Cells(1, 1).End(xlToRight).Column
  5.             If Sheet3.Cells(1, i).Value = CheckBox(x).Caption Then
  6.                 Sheet3.Columns(i).EntireColumn.Delete
  7.             End If
  8.         Next i
  9.     End If
  10. Next CheckBox
  11. Next x

however this doesn't work - any alternatives?