+ Reply to Thread
Results 1 to 2 of 2

Find and replace macro

  1. #1
    Registered User
    Join Date
    06-09-2020
    Location
    Belgium
    MS-Off Ver
    16.37
    Posts
    16

    Find and replace macro

    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.

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 2209 64-bit
    Posts
    21,647

    Re: Find and replace macro

    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.)
    Jeff
    | | |?| |?| |?| |?| | |:| | |?| |?|
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Find and Replace Macro to replace list of special characters
    By dcowiesmith in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-22-2021, 02:01 PM
  2. Replies: 0
    Last Post: 02-13-2021, 03:32 AM
  3. [SOLVED] Find and Replace Strings Within Modules Using Macro (Without Using Find Dialog)
    By exceere in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-30-2020, 09:08 PM
  4. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  5. Replies: 2
    Last Post: 06-12-2013, 03:48 PM
  6. Find/Replace Macro Using Replace Table
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2011, 11:00 AM
  7. Using Find and Replace to replace " in a macro
    By snail30152 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-13-2006, 06:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1