Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
On Error Resume Next
[z1] = "Dernière ligne " & [a1:k16].Find("*", , , , xlByRows, xlPrevious).Row
[z2] = "Dernière colonne " & [a1:k16].Find("*", , , , xlByColumns, xlPrevious).Column
If Err <> 0 Then [z1:z2] = "Pas de saisie en a1:k16"
Application.EnableEvents = True
End Sub