Option Explicit
Private Sub CommandButton1_Click()
Dim i As Long, LastRow As Long
Dim Lign As Long, colon As Long
Application.ScreenUpdating = False
LastRow = Feuil23.Range("B" & Rows.Count).End(xlUp).Row
Lign = 3
colon = 2
For i = LastRow To Lign Step -1
If Feuil23.Cells(i, colon) = "C" Then
Feuil23.Rows(i).EntireRow.Hidden = True
End If
Next i
Feuil23.Columns("A:B").EntireColumn.Hidden = True
Feuil23.Columns("G:G").EntireColumn.Hidden = True
Feuil23.Cells(4, 11).Select
Unload Me
Application.ScreenUpdating = True
End Sub