Sub test()
Dim i As Integer
For i = Range("B65536").End(xlUp).Row To 1 Step -1
If IsEmpty(Cells(i, 2)) Then Rows(i).Delete
Next i
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim lig As Long
With Sheets("Feuil1")
If .Range("A3") = "" Then Exit Sub
lig = .Cells(Rows.Count, 1).End(xlUp).Row
On Error Resume Next
With .Range("A4:A" & lig).SpecialCells(xlCellTypeBlanks)
.Delete Shift:=xlUp
End With
End With
End Sub
Sub Macro1()
Dim i As Integer
Application.ScreenUpdating = False
For i = 1000 To 1 Step -1
If ucase(range("A" & i).Value) <> "" And ucase(range("B" & i).Value) = "" then rows(i).Delete
Next i
Application.ScreenUpdating = True
End Sub
Mouais, autant de spontanéité pour répondre ICI peut-être...If ucase(range("A" & i).Value) <> "" And ucase(range("B" & i).Value) = "" then rows(i).Delete
Sub Macro1()
Columns(2).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
With Sheets("Feuil1")
If .Range("A3") = "" Then Exit Sub
For i = .Range("A65536").End(xlUp).Row To 4 Step -1
If .Range("A" & i) = "" Then .Rows(i).Delete
Next i
End With
End Sub
lig = .Cells(Rows.Count, 1).End(xlUp).Row
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim lig As Long
With Sheets("Séjours à coder")
If .Range("A3") = "" Then Exit Sub
lig = .Cells(Rows.Count, 1).End(xlUp).Row
.Range(.Cells(lig + 1, 1), .Cells(lig + 1, 13).End(xlDown)).Delete Shift:=xlUp
On Error Resume Next
With .Range("A4:M" & lig).SpecialCells(xlCellTypeBlanks)
.Delete Shift:=xlUp
End With
End With
End Sub
On Error Resume Next
With .Range("A4:A" & lig).SpecialCells(xlCellTypeBlanks).EntireRow
.Delete Shift:=xlUp
End With