|
楼主 |
发表于 2017-10-22 10:43
|
显示全部楼层
版主的嵌套循环用出了境界,修改后序号递增可以实现,但是回到原级别我没处理好,请版主过目
- Sub 按钮_Click()
- Set d = CreateObject("scripting.dictionary")
- arr = [a1].CurrentRegion
- Range("E2:E80").Clear
- For j = 0 To 3
- d(j) = 0
- Next j
- For j = 3 To UBound(arr)
- If Cells(j, 4) = "外购件" Or Cells(j, 4) = "标准件" Then
- arr(j, 5) = Cells(j, 2)
- Else
- For i = 1 To 4
- If InStr(arr(j, 1), i) > 0 Then
-
- If UCase(Cells(j, 3)) = "SLDASM" Then
-
- Debug.Print d(0), d(1), d(2), d(3)
-
- d(i - 1) = d(i - 1) + 1
- For k = i To 3
- d(k) = 0
- Next k
-
- Else
-
- For k = i - 1 To 2
- d(k) = 0
- Next k
-
- d(3) = d(3) + 1
-
-
- End If
- Debug.Print d(0), d(1), d(2), d(3)
- arr(j, 5) = "YTKQFMS-60" & Format(d(0), "00") & Format(d(1), "-0") & Format(d(2), "00") & "-" & Format(d(3), "000") & "-0"
- Exit For
- End If
- Next i
- End If
- Next j
- [a1].CurrentRegion = arr
- End Sub
复制代码 |
|