Find/Replace Window

[gmduece]

Hello,


Is there and way to code so that the Excel Find/Replace window opens, is resized to be bigger, and the window stays there waiting for user import. Macros doesn't like it

Thanks

 

[davesexcel]

You can use the VBA version of find/replace
If you wanted to find/replace something in column A

Sub ReplaceIt()
    Dim s As String, r As String
    s = InputBox("Replace what?")
    r = InputBox("Replace with what?")
    Columns("A").Replace What:=s, Replacement:=r, SearchOrder:=xlByColumns, MatchCase:=True
End Sub