1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| Sub Test()
Dim DerLig As Long
Dim MaPlage As Range, Cel As Range
With Worksheets("Feuil1") 'Nom de feuille à adapter
DerLig = .Range("A" & .Rows.Count).End(xlUp).Row
Set MaPlage = .Range("A2:A" & DerLig - 1)
For Each Cel In MaPlage
'Si les 2 dates sont identiques, on effectue le traitement
If Cel.Offset(1, 0) = Cel Then
'Calcul de la variation
Cel.Offset(1, 2) = Cel.Offset(1, 1) - Cel.Offset(0, 1)
'Remplissage colonne D
Select Case Cel.Offset(1, 2)
Case Is < 0
Cel.Offset(1, 3) = -1
Case Is > 0
Cel.Offset(1, 3) = 1
End Select
End If
Next
End With
End Sub |
Partager