1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| 'il y a 42 colonnes,
'on va commencer par compter vérifier le format des cellules,
For nb_colonn = 19 To 42
Cells(2, nb_colonn + 2) = Cells(2, nb_colonn + 2)
If Worksheets("Feuil1").Cells(2, nb_colonn).NumberFormat = "m/d/yyyy h:mm" Then
Cells(2, nb_colonn).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.EntireColumn.Insert
Cells(2, nb_colonn + 1).Select
Range(Selection, Selection.End(xlDown)).Select
Selection.TextToColumns Destination:=Cells(2, nb_colonn), DataType:=xlDelimited, _
TextQualifier:=xlDoubleQuote, ConsecutiveDelimiter:=True, Tab:=False, _
Semicolon:=False, Comma:=False, Space:=True, Other:=False, FieldInfo _
:=Array(Array(1, 1), Array(2, 1)), TrailingMinusNumbers:=True
End If
Next nb_colonn |
Partager