1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Sub Tri2()
Set debut = Range("A1") ' à adapter
n = debut.CurrentRegion.Rows.Count
nf = ActiveSheet.Name
Sheets(nf).Copy After:=Sheets(1) ' copie dans une feuille temporaire
nf2 = ActiveSheet.Name
Sheets(nf).Select
nbcol = debut.CurrentRegion.Columns.Count
debut.Offset(0, nbcol).EntireColumn.Insert Shift:=xlToRight
debut.Offset(1, nbcol) = 1
debut.Offset(1, nbcol).DataSeries Rowcol:=xlColumns, Type:=xlLinear, Date:=xlDay, _
Step:=1, Stop:=n - 1, Trend:=False
debut.Resize(n, nbcol + 1).Sort Key1:=debut.Offset(1, 0), Order1:=xlAscending, Header:=xlGuess
For i = 1 To n - 1
NoLigne = debut.Offset(i, nbcol) + 1
Rows(i + 1).RowHeight = Sheets(nf2).Rows(NoLigne).RowHeight
Next i
debut.Offset(0, nbcol).EntireColumn.Delete
Application.DisplayAlerts = False
Sheets(nf2).Delete
End Sub |
Partager