Sub 拆分统计()
'Sheet3.Range("A3:H8000").Select
'Selection.ClearContents
a = Sheet1.[A65536].End(3).Row
For i = 5 To a
b = Sheet3.[A65536].End(3).Row
If Sheet1.Cells(i, 10) = Sheet1.Cells(1, 1) Then
Sheet3.Range("a" & "b" & 1).Resize(, 8) = Sheet1.Range("a" & i).Resize(, 8).Value
End If
Next
End Sub
为什么 If Sheet1.Cells(i, 10) = Sheet1.Cells(1, 1) Then 显示错误呢