|
- Sub test()
- Dim Arr, Brr, Crr
- Dim k, i, j
- Set d = CreateObject("Scripting.Dictionary")
- Arr = Worksheets("明细表").[A1].CurrentRegion
- Brr = Worksheets("汇总表").[A1].CurrentRegion
- ReDim Crr(1 To UBound(Arr), 1 To 1)
- For i = 2 To UBound(Arr)
- If d.exists(Arr(i, 2)) Then
- m = d(Arr(i, 2))
- Crr(m, 1) = Crr(m, 1) & vbCrLf & Arr(i, 1) & ":" & Arr(i, 4)
- Else
- k = k + 1
- d(Arr(i, 2)) = k
- Crr(k, 1) = Arr(i, 1) & ":" & Arr(i, 4)
- End If
- Next
- For j = 3 To UBound(Brr)
- If Val(Brr(j, 5)) < 1 Then
- n = d(Brr(j, 1))
- With Worksheets("汇总表").Cells(j, 6)
- If Not .Comment Is Nothing Then .Cells(j, 6).Comment.Delete
- .AddComment
- .Comment.Text Text:=Crr(n, 1)
- .Comment.Visible = True
- .Comment.Shape.TextFrame.AutoSize = True
- End With
- End If
- Next
- End Sub
复制代码 |
|