测试了下,这里不能这么赋值。 由于不知道目的,改数组过渡,最后结果产生了(舍入)差别,我想是和公式有关。所以最好根据目的,重新设计方法。 Sub 表9() Dim a, b As Integer,arr Application.ScreenUpdating = False Sheets("表9").Range("b8:ac187").ClearContents Sheets("表10").Select For a = 8 To 26 Step 2 For b = 12 To 28 Step 2 If Worksheets("表9").Cells(a, 1).Value = Worksheets("表10").Cells(b, 1).Value Then arr = Worksheets("表10").Range(Cells(b, 2), Cells(b, 29)) Worksheets("表9").Cells(a, 2).Resize(UBound(arr), UBound(arr, 2)) = arr Erase arr arr = Worksheets("表10").Range(Cells(b + 1, 2), Cells(b + 1, 29)) Worksheets("表9").Cells(a + 1, 2).Resize(UBound(arr), UBound(arr, 2)) = arr Erase arr End If Next b Next a Sheets("表9").Select Application.ScreenUpdating = True End Sub [em11]
[此贴子已经被作者于2010-11-8 13:04:05编辑过] |