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 44 45 46 47 48 49 50 51 52 53 54
| Sub EnleverLesEspaces(plage As range)
Dim Cell As range
For Each Cell In plage.Cells
Cell.Value = Trim(Cell.Text)
Next Cell
End Sub
Function MiseAjour()
'sélection multiple'
Dim Depart As range
Set Depart = Worksheets("PRIX").range("A3:C200")
Dim Depart2 As range
Set Depart2 = Worksheets("PRIX").range("G3:G200")
Dim Destination As range
Set Destination = Worksheets("PRODUIT").range("A3:C200")
Dim Destination2 As range
Set Destination2 = Worksheets("PRODUIT").range("F3:F200")
'copie'
Depart.Copy Destination
Depart2.Copy Destination2
'tri des deux tableaux en respectant les formules'
Dim DepartColonne
Set DepartColonne = Worksheets("PRIX").range("A3:T200")
'fonction qui genere l'erreur erreur d'execution 424 objet requis '
EnleverLesEspaces (DepartColonne)
DepartColonne.Sort Key1:=Worksheets("PRIX").range("A2"), Order1:=xlAscending, Key2:=Worksheets("PRIX").range("B2"), Order2:=xlAscending, MatchCase:=False, Orientation:=xlTopToBottom
'ajout de ligne à chaque fin de marque et coloriage premiere occurence'
Dim x As Integer, i As Integer
x = Worksheets("PRIX").range("A65536").End(xlUp).Row
For i = x To 2 Step -1
If Cells(i, 1) <> Cells(i - 1, 1) And Cells(i, 1) <> "" Then
Cells(i, 1).Interior.ColorIndex = 4
Cells(i, 1).EntireRow.Insert
End If
Next i
Dim DestinationColonne
Set DestinationColonne = Worksheets("PRODUIT").range("A3:T200")
DestinationColonne.Sort Key1:=Worksheets("PRODUIT").range("A2"), Order1:=xlAscending, Key2:=Worksheets("PRODUIT").range("B2"), Order2:=xlAscending, MatchCase:=False, Orientation:=xlTopToBottom
End Function |
Partager