Private Function verlignevide(ByVal ligne As Long) As Boolean If Rows(ligne).SpecialCells(xlCellTypeConstants) Is Nothing Then verlignevide = True End If End Function
Private Function verlignevide(ByVal ligne As Long) As Boolean Dim toto As Range Set toto = Rows(ligne).SpecialCells(xlCellTypeBlanks) If toto.Areas.Count 1 And toto.Column 1 Then verlignevide = True End If End Function