[SIZE=2] [COLOR=NAVY]If[/COLOR] Left(Worksheets("Saison").Range("E4").Text, 3) = "DEP" [COLOR=NAVY]Then[/COLOR]
[/SIZE]
[SIZE=2] [COLOR=NAVY]If[/COLOR] Worksheets("Saison").Range("E4").Text [COLOR=NAVY]Like[/COLOR] "DEP*" [COLOR=NAVY]Then[/COLOR]
[/SIZE]
[SIZE=2] [COLOR=NAVY]If[/COLOR] Worksheets("Saison").Range("E4").Text [COLOR=NAVY]Like[/COLOR] "DEP*" [COLOR=NAVY]Then[/COLOR]
Range("D:AF,AK:AL").ColumnWidth = 7
Columns("C").ColumnWidth = 25
Range("G:G,J:J,M:M,P:P,S:S,V:V,Y:Y,AB:AB,AE:AE").EntireColumn.Hidden = [COLOR=NAVY]True
Else
With[/COLOR] Range("D:AF,AK:AL")
.EntireColumn.Hidden = [COLOR=NAVY]False[/COLOR]
.ColumnWidth = 6
[COLOR=NAVY]End With[/COLOR]
Columns("C").ColumnWidth = 19
[COLOR=NAVY]End If[/COLOR][/SIZE]