+ Reply to Thread
Results 1 to 2 of 2

updating find and replace values in a macro loop

  1. #1
    Registered User
    Join Date
    02-09-2013
    Location
    Durham, NC
    MS-Off Ver
    Excel 2003
    Posts
    1

    updating find and replace values in a macro loop

    I am writing a macro that includes search and replace values. I want the macro to run multiple times, and each time, the "find" value should be the previous find +1, and similarly with "replace". Example: for the first loop, I want it to find all references to the number 1 and replace with the number 2. In the next loop, find all the 2s, and replace with 3, etc. Help much appreciated!

  2. #2
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,791

    Re: updating find and replace values in a macro loop

    You stand a much better chance of getting help if you upload a small sample file to show the layout of your data and how you wish to get it "updated".

    Alf

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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