Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim MaCellule As Range Public Function PremiereLigneVide(CelluleDepart As Range, MonOrdre As XlSearchOrder, MaDirection As XlSearchDirection) As Long If MonOrdre = xlByRows Then PremiereLigneVide = Columns(MaCellule.Column).Find("", MaCellule, , , MonOrdre, MaDirection).Row Else PremiereLigneVide = Columns(MaCellule.Column).Find("", MaCellule, , , MonOrdre, MaDirection).Column End If End Function For j = 1 To nb Worksheets(j).Select Set MaCellule = [a1] LastLine = PremiereLigneVide(MaCellule, xlByRows, xlNext) Cells(LastLine, 1) = "*" Next j