On Jul 26, 3:58 pm, "Gary Keramidas" <GKeramidasATmsn.com wrote:
does this help?

Application.Dialogs(xlDialogFormulaFind).Show

--

Gary

wrote in message

oups.com...



When the workbook is opened, I'd like to be prompted to search and
replace. I know that the "macro" needs to be saved as a
"Workbook_open" subroutine. But I don't know how to get it then
prompt for the string to be searched for. The macro recorder records
nothing when I hit Ctrl+F. What's the code for bringing up the Search
and replace window?

Thanks,- Hide quoted text -

- Show quoted text -

Thanks Gary -- yes that worked.
1) How would I go about figuring this out myself -- other than asking
this newsgroup?
2) I'm trying to limit the scope of the search to column H. so, I did
this:
Columns("H:H").Select
Application.Dialogs(xlDialogFormulaFind).Show

But it searches in the whole sheet. How can I limit the search to
just column H?

Thanks,