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 ... ;-)
|