1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20
| Sub CelluleVide()
Dim plage As Range, myRange As Range, cel As Range
Dim premLigne As Integer, derLigne As Integer
Dim premColonne As Integer, derColonne As Integer, TotalLigne As Double
'Lignes et colonnes limitant la plage
premLigne = 74: derLigne = 85
premCol = 5: dercol = 28
'Set plage = [E74:AB85]
For ligne = premLigne To derLigne
'On teste si la somme des cellules de la ligne en cours est > 0
Set myRange = ActiveSheet.Range(Cells(ligne, premCol), Cells(ligne, dercol))
TotalLigne = Application.WorksheetFunction.Sum(myRange)
For Each cell In myRange
If TotalLigne > 0 Then
If IsEmpty(cell) Then cell.Value = 9999
End If
Next
Next
End Sub |
Partager