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
| Sub Brigades()
Dim M As String
Dim AM As String
Dim N As String
Dim nbre As String
Dim ExportQuantitesContenants As Variant
Dim Choix As Integer
Dim n1 As Double
Dim n2 As Variant
Dim n3 As Variant
Dim n4 As Variant
Dim n5 As Variant
Dim n6 As Variant
nbre = Application.WorksheetFunction.CountA(Sheets("choix").Range("2:80"))
n1 = MsgBox("05:30", "Matin", "")
n2 = MsgBox("13:30", "Matin", "")
n3 = MsgBox("13:31", "AM", "")
n4 = MsgBox("20:30", "AM", "")
n5 = MsgBox("22.15", "Nuit", "")
n6 = MsgBox("06:15", "Nuit", "")
M = ActiveSheet("Matin").Value
AM = Worksheets("AM").Value
N = Worksheets("Nuit").Value
ActiveSheet: Activate
Worksheets: Activate
Worksheets("Choix").Columns(A).ActiveCell.End(xlDown).Value = "M"
If "M" >= n1 And "M" <= n2 Then
Worksheets("Choix").Columns(A).Copy
Else: ActiveSheet("Matin").Columns("G").Paste
End If |
Partager