Jim Rech wrote:
Some or all Excel versions before Excel 2000 had this problem. When run
from a macro the way you're doing it Excel would only search the range
selected when the macro is run. This is usually just one cell. One way to
overcome this:

Private Sub CommandButton1_Click()
Cells.Select
Application.Dialogs(xlDialogFormulaFind).Show
ActiveCell.Select
End Sub

This was fixed in Excel 2002 and later.

Thanks a lot for your help !
Very nice to see such a compatibility ... ;-)