|
请教,怎样编写VBA码,实现自动编号功能,具体要求见附件中,
- Sub test()
- Dim A, B(1 To 99), i%, j%
- A = Sheet1.Range("a1").CurrentRegion
- For i = 2 To UBound(A)
- B(A(i, 2)) = B(A(i, 2)) + 1
- Next i
- For i = 1 To UBound(B)
- If B(i) > 3 Then
- j = j + 1
- B(i) = j
- Else
- B(i) = 0
- End If
- Next i
- For i = 2 To UBound(A)
- If B(A(i, 2)) > 0 Then A(i, 6) = B(A(i, 2))
- Next i
- [f1].Resize(UBound(A)) = Application.Index(A, 0, 6)
- End Sub
复制代码
自动分箱号2.rar
(11.32 KB, 下载次数: 22)
|
|