Sub 填充序号()
Dim rng As Range
Dim i As Integer
Dim tg As Integer
Dim x As Integer
Set rng = Range("a:a").SpecialCells(xlCellTypeConstants, 2)
If Err = 1004 Then MsgBox "当前列没有文本"
For Each rn In rng
If Len(rn.Value) <> 0 Then
i = rn.Row
tg = Left(Range("a" & i).Value, Len(Range("a" & i).Value) - 1)
For x = 0 To 4
Range("c" & i + x).Value = tg & x + 1
Next x
End If
Next rn
End Sub