Sub Click()
Dim A, B, i, j, k
i = Range("h65536").End(xlUp).Row
A = Range("h7:o" & i)
ReDim B(1 To UBound(A), 1 To UBound(A, 2))
For i = 1 To UBound(A) Step 3
For j = 1 To UBound(A, 2)
For k = 0 To 1
B(i, j) = B(i, j) + IIf(A(i + k, j) = 2, 1, 0)
Next k
Next j
Next i
[q:x] = ""
[q7].Resize(UBound(B), UBound(B, 2)) = B
End Sub
|