Sub Macro3()
'Parcourir toutes les cellules des Tableaux de H7 à AS7
Dim c As Range
With Sheets("Feuil1")
For Each c In .Range("$H$7:$J$7,$L$7:$Q$7,$S$7:$W$7,$Y$7:$AB$7,$AD$7:$AF$7,$AH$7:$AJ$7,$AL$7:$AN$7,$AP$7:$AS$7")
If c.Value <> "" Then
c = ""
c(0, 1) = ""
End If
Next
End With
End Sub