Open Search and replace dialog
I don't think it's available, does not appear to show in the Built-In Dialog
Box Argument Lists
However, see if one of these two approaches helps you.
Sub aaa()
Application.Dialogs(xlDialogFormulaReplace).Show
End Sub
Sub bbb()
Application.CommandBars.FindControl(ID:=1849).Exec ute
Application.CommandBars("Edit").Controls("Find..." ).Execute
End Sub
--
jb
"jkrons" wrote:
Is the a way to open the Search and replay dialog?
Application.Dialogs(xlDialogSearch).Show
opens the Filesearch task, and I haven't been able to locate any
xldialog keyword for the search and replace.
Jan
.
|