bonjour, je cherche a connaitre la première cellule vide de ma colonne (sa c'est ok) mais j'aimerais la garder la ligne en mémoire afin d’écrire automatiquement dans cette ligne.
Voici la macro que j’utilise actuellement :
Sub severity_index()
Dim i As Integer
With ThisWorkbook.Worksheets("severity_index")
.Cells(1, 5) = "x"
.Cells(2, 2) = "cL"
.Cells(2, 3) = "r"
.Cells(2, 4) = "t"
.Cells(2, 5) = "y"
.Cells(2, 6) = "y"
.Cells(2, 7) = "t"
.Cells(2, 8) = "p"
.Cells(2, 9) = "m"
.Cells(2, 10) = "p"
.Cells(2, 11) = "u"
.Cells(2, 12) = "c
End With
DerLigne
.Cells(i, 1) = "toto"
End Sub
Sub DerLigne()
Sheets("severity_index").Select
i = Range("A65536").End(xlUp).Offset(1, 0).Select
End Sub
Merci par avance de votre aide
Voici la macro que j’utilise actuellement :
Sub severity_index()
Dim i As Integer
With ThisWorkbook.Worksheets("severity_index")
.Cells(1, 5) = "x"
.Cells(2, 2) = "cL"
.Cells(2, 3) = "r"
.Cells(2, 4) = "t"
.Cells(2, 5) = "y"
.Cells(2, 6) = "y"
.Cells(2, 7) = "t"
.Cells(2, 8) = "p"
.Cells(2, 9) = "m"
.Cells(2, 10) = "p"
.Cells(2, 11) = "u"
.Cells(2, 12) = "c
End With
DerLigne
.Cells(i, 1) = "toto"
End Sub
Sub DerLigne()
Sheets("severity_index").Select
i = Range("A65536").End(xlUp).Offset(1, 0).Select
End Sub
Merci par avance de votre aide