|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
- Sub 插入行()
- Dim arr As Variant
- Dim brr()
- With ActiveSheet
- arr = Range("A1:C7")
- ReDim brr(1 To UBound(arr) * 2, 1 To UBound(arr, 2))
- For i = 2 To UBound(arr)
- If arr(i, 1) <> arr(i - 1, 1) Then
- j = j + 1
- brr(j, 1) = arr(i, 1)
- brr(j, 2) = "d1"
- brr(j, 3) = "E"
- j = j + 1
- brr(j, 1) = arr(i, 1)
- brr(j, 2) = "d2"
- brr(j, 3) = "E"
- End If
- Next i
- .[f1].CurrentRegion.ClearContents
- .[f1].Resize(i - 1, UBound(brr, 2)) = arr
- .Cells(i, 6).Resize(j, 3).Value = brr
- .Range("f:h").Sort .Range("F1"), , , , , , , 1
- End With
- End Sub
复制代码 |
评分
-
1
查看全部评分
-
|