Option Explicit
Sub Salaire()
Dim i%
For i = 5 To 74
Select Case Cells(i, 4)
Case Is = "3A"
Cells(i, 5) = 41290
Case Is = "3B"
Cells(i, 5) = 41390 'revoir ce salaire
Case Is = "3C"
Cells(i, 5) = 48520
Case Is = "3D"
Cells(i, 5) = "52145"
Case Is = "3E"
Cells(i, 5) = 55760
Case Is = "3F"
Cells(i, 5) = 59375
Case Is = "3G"
Cells(i, 5) = 62990
Case Is = "4A"
Cells(i, 5) = 56430
Case Is = "4B"
Cells(i, 5) = 60465
Case Is = "4C"
Cells(i, 5) = 64590
Case Is = "4D"
Cells(i, 5) = 68710
Case Is = "4E"
Cells(i, 5) = 72855
Case Is = "4F"
Cells(i, 5) = 76960
Case Is = "4G"
Cells(i, 5) = 81065
Case Is = "5A"
Cells(i, 5) = 72950
Case Is = "5B"
Cells(i, 5) = 77190
Case Is = "5C"
Cells(i, 5) = 81435
Case Is = "5D"
Cells(i, 5) = 85670
Case Is = "5E"
Cells(i, 5) = 89915
Case Is = "5F"
Cells(i, 5) = 94150
Case Is = "5G"
Cells(i, 5) = 98385
Case Is = "6A"
Cells(i, 5) = 90890
Case Is = "6B"
Cells(i, 5) = 95565
Case Is = "6C"
Cells(i, 5) = 100340
Case Is = "6D"
Cells(i, 5) = 104915
Case Is = "6E"
Cells(i, 5) = 109595
Case Is = "6F"
Cells(i, 5) = 114265
Case Is = "6G"
Cells(i, 5) = 118935
Case Is = "7A"
Cells(i, 5) = 94440
Case Is = "7B"
Cells(i, 5) = 101905
Case Is = "7C"
Cells(i, 5) = 109375
Case Is = "7D"
Cells(i, 5) = 116835
Case Is = "7E"
Cells(i, 5) = 124305
Case Is = "7F"
Cells(i, 5) = 131770
Case Is = "7G"
Cells(i, 5) = 139235
Case Is = "8A"
Cells(i, 5) = 131770
Case Is = "8B"
Cells(i, 5) = 140560
Case Is = "8C"
Cells(i, 5) = 149340
Case Is = "8D"
Cells(i, 5) = 158130
Case Is = "8E"
Cells(i, 5) = 166920
Case Is = "8F"
Cells(i, 5) = 175705
Case Is = "8G"
Cells(i, 5) = 184490
Case Is = "9A"
Cells(i, 5) = 166435
Case Is = "9A"
Cells(i, 5) = 166435
Case Is = "9B"
Cells(i, 5) = 180995
Case Is = "9C"
Cells(i, 5) = 195560
Case Is = "9D"
Cells(i, 5) = 172105
Case Is = "9E"
Cells(i, 5) = 224680
Case Is = "9F"
Cells(i, 5) = 239240
Case Is = "9G"
Cells(i, 5) = 253800
Case Is = "10A"
Cells(i, 5) = 241145
Case Is = "10B"
Cells(i, 5) = 254035
Case Is = "10C"
Cells(i, 5) = 266625
Case Is = "10D"
Cells(i, 5) = 279225
Case Is = "10E"
Cells(i, 5) = 291820
Case Is = "10F"
Cells(i, 5) = 304420
Case Is = "10G"
Cells(i, 5) = 317020
Case Is = "11A"
Cells(i, 5) = 367420
Case Is = "11B"
Cells(i, 5) = 317020
Case Is = "11C"
Cells(i, 5) = 329615
Case Is = "11D"
Cells(i, 5) = 342210
Case Is = "11E"
Cells(i, 5) = 354805
Case Is = "11F"
Cells(i, 5) = 367405
Case Is = "11G"
Cells(i, 5) = 380005
Case Is = "12A"
Cells(i, 5) = 367405
Case Is = "12B"
Cells(i, 5) = 380000
Case Is = "12C"
Cells(i, 5) = 392605
Case Is = "12D"
Cells(i, 5) = 405200
Case Is = "12E"
Cells(i, 5) = 417795
Case Is = "12F"
Cells(i, 5) = 430395
Case Is = "12G"
Cells(i, 5) = 442995
End Select
Next i
End Sub