|
- Sub Macro1()
- Dim arr, brr, j&, n&
- h = Cells(Rows.Count, 1).End(xlUp).Row '行
- l = Cells(1, Columns.Count).End(xlToLeft).Column '列
- arr = Range("a1").Resize(h, l)
- n = UBound(arr)
- ReDim brr(1 To 1, 1 To UBound(arr, 2))
- For j = 1 To UBound(arr, 2)
- x = arr(n - 3, j) - arr(n - 2, j)
- If x >= 0 Then brr(1, j) = x
- Next
- With [a1].Offset(n - 2, 0).Resize(1, UBound(brr, 2))
- .Value = brr
- .SpecialCells(xlCellTypeBlanks).EntireColumn.Delete
- End With
- End Sub
复制代码 |
|