1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43
| Sub test()
Const MaColonne = "A"
Dim valsM As Long, resultM
Dim valsN As Long, resultN
Dim valsO As Long, resultO
With Sheets("toto")
i = .cells(.Rows.Count, MaColonne).Offset(, 1).End(xlUp).Row
If i <= .cells(.Rows.Count, MaColonne).End(xlUp).Row Then _
i = .cells(.Rows.Count, MaColonne).End(xlUp).Row
valsM = .Columns(MaColonne).Resize(i, 12).Value
valsN = .Columns(MaColonne).Resize(i, 12).Value
valsO = .Columns(MaColonne).Resize(i, 12).Value
ReDim resultM Preserve (LBound(valsM) To UBound(valsM))
ReDim resultN(LBound(valsN) To UBound(valsN))
ReDim resultO(LBound(valsO) To UBound(valsO))
For i = LBound(valsM) To UBound(valsM)
resultM(i) = Format(valsM(i, 2), "yyyy-MM")
resultN(i) = Format(valsN(i, 2), "WW")
resultO(i) = Format(valsO(i, 2), "JJ")
Next i
.Columns(MaColonne).Offset(0, 13).Resize(UBound(resultM) - LBound(resultM) + 1).Value_
= Application.Transpose(resultM)
.Columns(MaColonne).Offset(0, 14).Resize(UBound(resultN) - LBound(resultN) + 1).Value _
= Application.Transpose(resultN)
.Columns(MaColonne).Offset(0, 15).Resize(UBound(resultO) - LBound(resultO) + 1).Value _
= Application.Transpose(resultO) |
Partager