答案1
尝试一下:
Sub multies()
Dim N As Long, i As Long
x = Application.InputBox(prompt:="enter repetition factor", Type:=1)
N = Cells(Rows.Count, "A").End(xlUp).Row
k = 2
For i = 2 To N
v = Cells(i, 1).Value
For j = 1 To x
Cells(k, 2).Value = v
k = k + 1
Next j
Next i
End Sub