[B]Sub ANNULE_Masquage()[/B]
With Cells
.Columns.Hidden = False
.Rows.Hidden = False
End With
End Sub
[B]Sub test2()[/B]
Dim col As Long
Dim lig As Long
Application.ScreenUpdating = False
col = InputBox("Numéro de colonne où commencer le masquage", "Masquage colonnes inutiles")
If col > 12 Then
Exit Sub
Else
Columns(col).Offset(, 1).Select
Range(Selection, Selection.End(xlToRight)).EntireColumn.Hidden = True
End If
lig = InputBox("Numéro de ligne où commencer le masquage", "Masquage lignes inutiles")
If lig > 32 Then
Exit Sub
Else
Rows(lig).Offset(1, 0).Select
Range(Selection, Selection.End(xlDown)).EntireRow.Hidden = True
End If
End Sub