Sub text()
s = "shuju"
With Range("c10:s" & Range("i65536").End(3).Row)
arr = .Value
r = UBound(arr)
For i = 1 To r Step 2
m = m + 1
n = 0
For k = i To i + 1
If k > r Then Exit For
arr(k, 1) = k
For l = 2 To 17 Step 1
arr(k, l) = arr(1, l)
Next
n = n + 1
arr(k, 6) = s & m & n
Next
Next
.Value = arr
End With
End Sub
Sub text()
s = "shuju"
On Error Resume Next
arr = Range("c10:s" & Range("i65536").End(3).Row)
For i = 1 To UBound(arr)
m = (i - 1) \ 3 + 1
n = (i - 1) Mod 3 + 1
arr(i, 6) = s & m & n
arr(i, 1) = arr(i - 1, 1) + 1
For j = 2 To UBound(arr, 2)
If arr(i, j) = "" Then arr(i, j) = arr(i - 1, j)
Next
Next
Range("c10:s" & Range("i65536").End(3).Row) = arr
End Sub