Isso funciona no Windows, experimente no seu MAC:
Sub KolumnKiller()
Dim N As Long, i As Long
With Application.WorksheetFunction
N = Cells(1, Columns.Count).End(xlToLeft).Column
For i = N To 1 Step -1
If .CountA(Columns(i)) < 2 Then Cells(1, i).EntireColumn.Delete
Next i
End With
End Sub