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
|