|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
如上图,为非空单元格所在行加边框。
备注:行数不是固定的,三个按钮代码不同,所得结果也是不同的。
代码如下:
Sub test3D()
Dim r%, i%
Dim arr, brr
With Worksheets("源数据")
r = .Cells(.Rows.Count, 1).End(xlUp).Row
arr = .Range("A2:D" & r)
ReDim brr(1 To UBound(arr), 1 To 5)
m = 0
For i = 1 To UBound(arr)
If arr(i, 2) = "足金3D硬金" Then
m = m + 1
brr(m, 1) = m
brr(m, 2) = arr(i, 1)
brr(m, 3) = arr(i, 2)
brr(m, 4) = arr(i, 3)
brr(m, 5) = arr(i, 4)
End If
Next
End With
With Worksheets("入库单")
Sheet2.Range("a5:j50").ClearContents
.Range("a5").Resize(UBound(brr), UBound(brr, 2)) = brr
Sheet2.Cells(r + 1, 2) = "合计"
Sheet2.Cells(r + 1, 5) = Application.WorksheetFunction.Sum(Range("e5:e" & r))
End With
End Sub
|
|