|
发表于 2017-6-9 11:41
|
显示全部楼层
本楼为最佳答案
- Sub aaa()
- Dim s$, d As Object
- Set d = CreateObject("scripting.dictionary")
- s = "DADA"
- For i = 3 To [e65536].End(3).Row
- d(Cells(i, 5).Value) = Cells(i, 6)
- Next i
- For i = 2 To [a65536].End(3).Row
- If Cells(i, 3) = "A" Then
- If d(Cells(i, 2).Value) > 0 Then
- Cells(i, 3) = s
- d(Cells(i, 2).Value) = d(Cells(i, 2).Value) - 1
- End If
- End If
- Next i
- End Sub
复制代码 |
|