Voila, un SELECT CASE bien simple:


For x = 0 To 6

Select Case JT
Case JT = "M", "S", "N"
ActiveCell.Offset(0, 1).Value = CDbl(8.25)
...