|
前面新增列A列和B列单元格有数据,要什么处理上面的条件保持不变
- Option Explicit
- Sub ta()
- Dim ar, br, i%, j&
- ar = Range("C3:H" & Cells(Rows.Count, 3).End(3).Row)
- ReDim br(1 To UBound(ar), 1 To 2)
- For i = 2 To UBound(ar)
- br(i, 1) = Format((ar(i, 1) + ar(i, 2) + ar(i, 3) + ar(i, 4) + ar(i, 5) + ar(i, 6)) / 6, "0.0000")
- br(i, 2) = Int(br(i, 1) + 0.5)
- Next i
- [l3].Resize(UBound(br), 2) = br
- End Sub
复制代码
|
|