Sub test_2()
Dim x As Range, y As Range
With Feuil1
Set x = .Cells.Find("*", .Cells(.Rows.Count, .Columns.Count), xlValues, , 1, 2, 0)
Set y = .Cells.Find("*", .Cells(.Rows.Count, .Columns.Count), xlValues, , 2, 2, 0)
.Range(.Cells(1, 1), .Cells(x.Row, y.Column)).Select
End With
End Sub