Find/Replace all in VBA by using VBA code?

[samumr]

Hi all,

I am new to macro and learning based on my activity.

I have created for macro for weekly report and its worked fine.
But I am facing one issue, ie.
Every week I need to change only few things in code which wrote already (ex: this week is WW32_M and for next week I need to change WW33_M)

So what I am searching for before proceed/start my macro code it should ask for dialog box to “find what and what to replace” and it will “replace all” in my code.

After replaced then my vba code should start.

Pl guide/help me on this.

Thanks.

[hussainsio]

Sub FRVBA()
Dim str As String
Dim str1 As Integer
str1 = InputBox("Enter the desired Value", "Attention")
str = "WW" & str1 & "_M"
MsgBox str
End Sub

[protonLeah]

Post the code or maybe a workbook:
To attach a Workbook
(please do not post pictures or links)

• Click Advanced (next to quick post),
• Scroll down until you see "Manage Attachments",
• Click that then select "add files" (top right corner).
• Click "Select Files" find your file, click "open" click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Click "Done" at bottom right to close the Attachment Manager.
• Click "Submit Reply"

[Sean Thomas]

Unless you really need to change a lot of code, if it is just certain variables i.e. WW32_M

then use a cell in a sheet and use that in your code. Then all you need to do is change that one cell instead of changing your code.
You can always hide the sheet from prying eyes.

i.e. on sheet5 A1 enter WW32_M

in your code

Please Login or Register  to view this content.

[samumr]

Hi Thanks for all your support,

but its changed in formulas and that formula is not updated properly.

any idea for this.

it should replace in formula too without changes required formula.

--Sampath

[protonLeah]

I asked you to post your code because everyone is just guessing what you are working with.

[Norie]

I'm pretty sure this can be handle without a find/replace.

Post the code.

[samumr]

Hi,

Thanks for all your support.

I got the code after several searches.

My Macro is working fine.

Thanks a lot again.

--Sampath