|
楼主 |
发表于 2017-4-6 13:22
|
显示全部楼层
你好,
改完后, 发现批号无法卡重复批号了
Function twolots() As Boolean
Dim d, arr, i, lotno, xrr
Set d = CreateObject("scripting.dictionary")
arr = Sheets("CC").Range("a1:a" & Sheets("CC").[a65536].End(3).Row)
For i = 5 To UBound(arr)
d(CStr(arr(i, 1))) = ""
Next
xrr = Split(Me.Range("G2").Value, "-")
'=====================================================
If [g2] <> "" Then lotno = IIf(UBound(xrr) = 1, xrr(0) & "-" & xrr(1), xrr(0))
'=====================================================
If d.exists(lotno) Then MsgBox "twolots, pls check!": twolots = True
End Function
|
|