Sub first_cell_not_blank()
Dim t, derlig&, i&
With Sheets("Feuil1")
If .FilterMode Then .ShowAllData
derlig = .Cells(.Rows.Count, "a").End(xlUp).Row
t = Range("a1:a" & derlig + 1).Formula
For i = 2 To UBound(t)
If t(i, 1) <> "" Then Application.Goto .Cells(i, "a"): Exit Sub
Next i
MsgBox "Aucune cellule avec valeur ou formule.", vbCritical
End With
End Sub