Salut le fil...
Je pense que tu n'y arrives pas car cela doit faire partie d'un bloc Whith End With sinon en dur WorkSheets("Tafeuille").Cells.Find...
Tiens un fonction toute prête du blog de Pierre Fauconnier, faut y prendre le temps il y a tout un tas de bonnes choses.
Function getLastCellWithData(sh As Worksheet) As Range
Dim r As Long: r = 1
Dim c As Long: c = 1
Dim EnableEvents As Boolean
Dim cell As Range
On Error GoTo EndHandler
EnableEvents = Application.EnableEvents
Application.EnableEvents = False
If sh.Cells.SpecialCells(xlCellTypeLastCell).Address <> "$A$1" Then
Set cell = sh.Cells.Find(what:="*", after:=sh.Cells(1, 1), LookIn:=xlValues, lookat:=xlWhole, _
searchorder:=xlByRows, SearchDirection:=xlPrevious)
If Not cell Is Nothing Then
r = cell.Row
c = sh.Cells.Find(what:="*", after:=sh.Cells(1, 1), LookIn:=xlValues, lookat:=xlWhole, _
searchorder:=xlByColumns, SearchDirection:=xlPrevious).Column
End If
End If
Set getLastCellWithData = sh.Cells(r, c)
EndHandler:
Application.EnableEvents = EnableEvents
End Function
Bonne prog