Sub Lgn_vides()
Dim i&, j&, k&
With Application
.EnableEvents = False
.ScreenUpdating = False
.Calculation = xlCalculationManual
End With
With Sheets("RdV_faits")
.Unprotect Password:=""
j = .Range("A" & .Rows.Count).End(xlUp).Row
k = .Range("XFD1").End(xlToLeft).Column
For i = k To 18 Step -1
If Application.CountA(.Cells(1, i).Range("A1:A" & j)) = 0 Then .Cells(1, i).Range("A1:A" & j).Delete Shift:=xlToLeft
Next i
For i = j To 1 Step -1
If Application.CountA(.Range(.Cells(i, 1).Address & ":" & .Cells(i, k).Address)) = 0 Then .Range(.Cells(i, 1).Address & ":" & .Cells(i, k).Address).Delete Shift:=xlUp
Next i
.Protect Password:="", DrawingObjects:=True, Contents:=True, Scenarios:=True
End With
With Application
.EnableEvents = True
.ScreenUpdating = True
.Calculation = xlCalculationAutomatic
End With
End Sub