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
| Sub MAJ_Liste()
Dim i As Integer
Dim Nom As String
For i = 2 To Sheets.Count - 1
Nom = Nom & Sheets(i).Name & ","
Next i
Nom = Nom & Sheets(Sheets.Count).Name
Range("i:i").Validation.Delete
Range("i2:i1000").Validation _
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Nom
Range("j:j").Validation.Delete
Range("j2:j1000").Validation _
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Nom
Range("k:k").Validation.Delete
Range("k2:k1000").Validation _
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:=Nom
End Sub
Sub Envoi_par_arbitre()
Dim R As Range
Dim i As Integer
Dim j As Integer
For i = 2 To Sheets.Count
Sheets(i).Range("a2:k1000").ClearContents
Next
For Each R In Range("i2:k1000")
If R.Value <> 0 Then
R.EntireRow.Copy (Sheets(R.Value).Range("A65536").End(xlUp).Offset(1, 0))
End If
Next
End Sub |
Partager