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
| Sub Reformate()
Dim LastLig As Long, i As Long
Dim Tb As Variant
Application.ScreenUpdating = False
With Worksheets("exemple")
Tb = .UsedRange.Value
LastLig = UBound(Tb, 1)
For i = 1 To LastLig
Former Tb, i
Next i
.Range("A1").Resize(LastLig, UBound(Tb, 2)) = Tb
End With
End Sub
Private Sub Former(Tablo As Variant, ByVal Lig As Long)
Dim i As Integer, j As Integer, n As Integer
n = UBound(Tablo, 2)
i = n
Do While Tablo(Lig, i) = "" And i > 1
i = i - 1
Loop
If i < n Then
For j = i To 1 Step -1
Tablo(Lig, n - i + j) = Tablo(Lig, j)
Tablo(Lig, j) = Empty
Next j
End If
End Sub |
Partager