|
本帖最后由 hasyh2008 于 2022-4-27 17:29 编辑
Sub 序号()
Dim Rc%, Arr(), K%
Arr = Sheet1.Range("A1").CurrentRegion
For Rc = 2 To UBound(Arr)
If Arr(Rc, 2) <> "" Then
K = 1
Arr(Rc, 3) = Arr(Rc, 2) & "01"
Else
K = K + 1
Arr(Rc, 3) = VBA.Left(Arr(Rc - 1, 3), VBA.Len(Arr(Rc - 1, 3)) - 2) & Application.WorksheetFunction.Text(K, "00")
End If
Next Rc
Sheet1.Range("A1").Resize(UBound(Arr), UBound(Arr, 2)) = Arr
End Sub
|
|