Select Case Range("A1").Value Case "VU" toto = "#,##0.00 $ \HT;[Red]-#,##0.00 $ \HT" Case "VP" toto = "#,##0.00 $ \TTC;[Red]-#,##0.00 $ \TTC" End Select For i = 3 To 5 Range("A1").Offset(0, i).NumberFormat = "#,##0.00 $ \HT;[Red]-#,##0.00 $ \HT" Next Range("A1").Select
For i = 3 To 5 If toto <> "" Then range("A1").Offset(0, i).NumberFormat = toto Next