|
发表于 2014-8-20 05:21
|
显示全部楼层
本楼为最佳答案
- Sub Macro1()
- Dim arr, brr, rng As Range, i&, n&
- arr = Range("b8").CurrentRegion
- ReDim brr(1 To UBound(arr) * 2, 1 To 1)
- For i = 1 To UBound(arr)
- brr(2 * i - 1, 1) = arr(i, 1)
- Next
- Set rng = Application.InputBox("请用鼠标选择顶点单元格", Type:=8)
- n = UBound(brr)
- rng.Resize(n).Clear
- rng.Resize(n) = brr
- With rng.Resize(2)
- .Merge
- .Copy
- End With
- Cells(rng.Row + 2, rng.Column).Resize(n - 2).PasteSpecial Paste:=xlPasteFormats
- rng.Resize(n).Borders().Weight = xlThin
- Application.CutCopyMode = False
- End Sub
复制代码 |
|