Find and replace macro

**Ikke1996** · 02-07-2022, 06:31 AM

I would like to find and replace numbers or text in formulas. I have a macro assigned to a symbol which, when I press it, presents a pop-up screen.
For example in the worksheet "Datasheet1" there are a lot of formulas that have the cell K200 in them. I would like to change them to K300 by using the pop-up screen.

I've come across the formula below, but it doesn't work unfortunately.

Please Login or Register  to view this content.

Presenting a worksheet is kind of difficult because of the specifics.

**6StringJazzer** · 02-07-2022, 07:40 AM

What you are describing is just a simple find & replace that can easily be done with the Home > Find & Select > Replace feature on the ribbon. Why do you want to do this with VBA? Why duplicate an existing feature that actually has more options?

(It would make sense if you wanted to do something more complicated. For example, I developed a Find & Replace macro that uses regexp.)

Find and replace macro

LinkBack

Thread Tools

Rate This Thread

Display

Find and replace macro

Re: Find and replace macro

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Find and Replace Macro to replace list of special characters

Find and Replace dialogue keeps closing when clicking Find Next / Replace / Replace All

[SOLVED] Find and Replace Strings Within Modules Using Macro (Without Using Find Dialog)

Need a macro to find and replace words in word using excel column 1(find) column (replace)

Macro- Find the second of two identical rows and find and replace the contents of second

Find/Replace Macro Using Replace Table

Using Find and Replace to replace " in a macro

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions