Sub demo()
n = 7
a = [BA1:GN1000]
Set Rng = [ZZ1:ZZ1000]
For x = 1 To UBound(a, 2)
For y = 1 To UBound(a)
If a(y, x) <> "" Then c = c + 1
Next
If c > n Then Set Rng = Union(Rng, [AZ1:AZ1000].Offset(, x))
c = 0
Next
Rng.ClearContents
End Sub
Sub demo()
n = 3
a = [BA1:GN1000]
Set Rng = [ZZ1:ZZ1000]
For x = 1 To UBound(a, 2)
For y = 1 To UBound(a)
If a(y, x) <> "" Then c = c + 1
Next
If c > n Then Set Rng = Union(Rng, [CZ1:CZ1000].Offset(, x))
c = 0
Next
Rng.ClearContents
End Sub
Sub demo()
n = 7
a = [BA1:GN1000]
Set Rng = [ZZ1:ZZ1000]
For x = 1 To UBound(a, 2)
For y = 1 To UBound(a)
If a(y, x) <> "" Then c = c + 1
Next
If c > n Then Set Rng = Union(Rng, [AZ1:AZ1000].Offset(, x))
c = 0
Next
Rng.ClearContents
End Sub