Sub ffffff()
Dim Aarray(9, 9) As Integer
Dim i As Integer
Dim j As Integer
For i = 0 To 9
For j = 0 To 9
Aarray(i, j) = 0
Aarray(i, j) = 0
Next
Next
For i = 0 To 100
For j = 0 To 2
Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j).Value) = Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j).Value) + 1
Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 1).Value) = Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 1).Value) + 1
Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 2).Value) = Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 2).Value) + 1
Next
Next
For i = 0 To 9
For j = 0 To 9
Sheet1.Cells(i + 10, j + 10).Value = Aarray(i, j)
Next
Next
End Sub
Dim Aarray(9, 9) As Integer
Dim i As Integer
Dim j As Integer
For i = 0 To 9
For j = 0 To 9
Aarray(i, j) = 0
Aarray(i, j) = 0
Next
Next
For i = 0 To 100
For j = 0 To 2
Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j).Value) = Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j).Value) + 1
Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 1).Value) = Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 1).Value) + 1
Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 2).Value) = Aarray(Sheet1.cell(i, j).Value, Sheet1.cell(i + 1, j + 2).Value) + 1
Next
Next
For i = 0 To 9
For j = 0 To 9
Sheet1.Cells(i + 10, j + 10).Value = Aarray(i, j)
Next
Next
End Sub
同意,粗心大意。他最后的循环中就对了:
Sheet1.Cells(i + 10, j + 10).Value =