How to display Excel 2002+ "Find & Replace" dialog via VBA
 

Using VBA, one can display most if not all of Excel's builtin
dialogs,
using code such as:

application,dialogs(xlDialogFormulaReplace).show


The object browser shows the enum for the constants (such as
xlDialogFormulaReplace in the example above). However, I cant find
such a constant for the new single box "Find & Replace" dialog
introduced in Excel 2002 and beyond and described in KB288291. Any
ideas on how to display this puppy?


Major

How to display Excel 2002+ "Find & Replace" dialog via VBA
 

Cells.Replace What:="<your criteria", Replacement:="<Your criteria",
LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False,
ReplaceFormat:=False

works for me.

--
Hth

Kassie Kasselman
Change xxx to hotmail


" wrote:

Using VBA, one can display most if not all of Excel's builtin
dialogs,
using code such as:

application,dialogs(xlDialogFormulaReplace).show


The object browser shows the enum for the constants (such as
xlDialogFormulaReplace in the example above). However, I cant find
such a constant for the new single box "Find & Replace" dialog
introduced in Excel 2002 and beyond and described in KB288291. Any
ideas on how to display this puppy?


Major