Sub demo()
a = [ha1:mn1000]:ReDim b(1 To UBound(a, 2), 99)
For i = 1 To UBound(a)
For j = 1 To UBound(a, 2): b(j, a(i, j)) = 1: Next
Next
a = [ba1:gn1000]
For x = 1 To UBound(a, 2)
For y = 1 To UBound(a)
If a(y, x) = 0 Then Exit For
If b(x, a(y, x)) Then:[az1:az1000].Offset(, x).ClearContents:exit for
Next
Next
End Sub
祝順心,南無阿彌陀佛!