|
[广告] Excel易用宝 - 提升Excel的操作效率 · Excel / WPS表格插件 ★ 免费下载 ★ ★ 使用帮助★
- Sub bchs()
- Dim arr, i&, j&, r&
- ReDim arr(1 To 17, 1 To 7)
- r = Columns("A:A").Find(what:="填表人:", LookIn:=xlValues, lookat:=xlWhole, searchorder:=xlByRows, searchdirection:=xlPrevious).Row
- arr = Range("A5:G21")
- arr(r - 4, 1) = ""
- arr(r - 4, 4) = ""
- arr(r - 5, 1) = ""
- arr(r - 5, 3) = ""
- arr(UBound(arr), 1) = "填表人:"
- arr(UBound(arr), 4) = "负责人:"
- arr(UBound(arr) - 1, 1) = "合计"
- Range("A5:G21").Clear
- Range("A5:G21") = arr
- Range("A" & r - 1 & ":B" & r - 1).UnMerge
- Range("A20:B20").Merge
- Range("A5:G20").Borders.LineStyle = 1
- End Sub
复制代码 |
|