Experimente:
Sub InsereNúmeros()
Dim k As Long, e As Long, d As Long
For k = 13 To Cells(Rows.Count, 3).End(3).Row
If InStr(1, Cells(k, 3), " ") > 0 Then
On Error Resume Next
e = Left(Cells(k, 3), InStr(1, Cells(k, 3), " ") - 1)
d = Right(Cells(k, 3), Len(Cells(k, 3)) - InStrRev(Cells(k, 3), " ", , 1))
Cells(k, 3) = e
Cells(k, 3).AutoFill Range(Cells(k, 3), Cells(k + d - e, 3)), xlFillSeries
k = k + d - e
End If
Next k
End Sub
Postado : 12/07/2017 6:58 am