1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
|
Sub convertir()
Dim Fin As Long, i As Long
Fin = Cells(Rows.Count, "A").End(xlUp).Row
For i = 3 To Fin
Range("C" & i).Copy Range("G" & i)
Next i
For i = 3 To Fin
Selection.TextToColumns Destination:=Range("G" & i), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=False, Tab:=True, _
Semicolon:=False, Comma:=False, Space:=False, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1), Array(3, 1), Array(4, 1), Array(5, 1), Array(6, 1), _
Array(7, 1), Array(8, 1), Array(9, 1)), TrailingMinusNumbers:=True
SendKeys "{ENTER}", True
Next i
End Sub |
Partager