Sub Proposition3_UnionRangeSelection()
Dim SelectRange As Range
Dim ExclusionCell As Range
Set SelectRange = Union(Range('A1:A50'), Range('B1:B9'), Range('B11:B50'), Range('C1:Z50'))
SelectRange.Select
Selection.ClearContents
'Que je préferai écrire directement Sans Selection :
'SelectRange.ClearContents
End Sub