|
当相同型号与名称出现一样的编号出现提示
- Sub pd()
- Dim d As Object
- Dim sj, tmp
- Dim i, j
- Set d = CreateObject("scripting.dictionary")
- With Sheets("Sheet1")
- sj = .Range("d2:d" & .Range("d2").End(xlDown).Row).Value
- End With
- For i = 1 To UBound(sj)
- tmp = VBA.Split(sj(i, 1), "/")
- For j = 0 To UBound(tmp)
- If d.exists(tmp(j)) Then
- '提示
- MsgBox "D" & i + 1 & "的" & tmp(j) & "和" & "D" & d(tmp(j)) & "相同"
- End
- Else
- d(tmp(j)) = i + 1 & "的" & tmp(j)
- End If
- Next j
- Next i
- End Sub
复制代码
Book1b.rar
(13.78 KB, 下载次数: 24)
|
|