|
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
本帖最后由 同心/ty 于 2023-4-19 15:48 编辑
求修改代码,附件是论坛一位老师写的,但如果标题上插入5行,代码如何修改,请大神指点。
Sub dd()
Dim d As Object, arr, brr, i&, j&, k
Set d = CreateObject("scripting.dictionary")
arr = Range("e1:e" & [a1].CurrentRegion.Rows.Count)
For i = 2 To UBound(arr)
d(arr(i, 1)) = d(arr(i, 1)) & "," & i
Next
ReDim brr(2 To UBound(arr), 1 To 1)
For i = 2 To UBound(arr)
k = Mid(Replace(d(arr(i, 1)), "," & i, ""), 2)
If Len(k) Then brr(i, 1) = "与第" & k & "行重复"
Next
[h2].Resize(UBound(arr) - 1, 1) = brr
Set d = Nothing
End Sub
|
|