|
本帖最后由 hasyh2008 于 2022-5-12 08:54 编辑
Sub 编号()
Dim Arr
Dim Rc%, K%
Arr = ActiveSheet.Range("A1").CurrentRegion
K = 1
For Rc = 2 To UBound(Arr)
If Arr(Rc, 1) = "收" Then
Arr(Rc, 2) = Application.Text(K, "000")
K = K + 1
End If
Next Rc
For Rc = 2 To UBound(Arr)
If Arr(Rc, 1) = "付" Then
Arr(Rc, 2) = Application.Text(K, "000")
K = K + 1
End If
Next Rc
ActiveSheet.Range("A1").Resize(UBound(Arr, 1), UBound(Arr, 2)) = Arr
End Sub
|
|