+ Reply to Thread
Results 1 to 3 of 3

VBA to find and replace on specific sheets

  1. #1
    Registered User
    Join Date
    06-24-2019
    Location
    Buffalo, NY
    MS-Off Ver
    2016
    Posts
    11

    VBA to find and replace on specific sheets

    Hello,

    I'm writing a macro to find and replace specific values (from ranges) on specific worksheets. Each of the "find" values has the corresponding worksheet name next to it, along with the value to replace (source data in example file).

    Basically I just need the macro to loop through the workbook and for each specific worksheet listed, find and replace those specific values on that specific sheet. Any help writing this code would be greatly appreciated.
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    18,527

    Re: VBA to find and replace on specific sheets

    Try
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-24-2019
    Location
    Buffalo, NY
    MS-Off Ver
    2016
    Posts
    11

    Re: VBA to find and replace on specific sheets

    Seems to work perfectly. Thank you so much.

+ 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] macro find and replace in a specific column specific words to an abreviation
    By JEAN1972 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-19-2018, 06:05 AM
  2. [SOLVED] Find & Replace All Sheets Using VBA
    By tmontg2 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-28-2012, 04:06 PM
  3. Find/Replace VBA for a specific column
    By boolean in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-15-2011, 10:17 PM
  4. find and replace specific characters
    By wkilc in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-21-2010, 02:59 PM
  5. Find-Replace in specific rows
    By ajaykgarg in forum Excel General
    Replies: 3
    Last Post: 06-10-2010, 02:31 AM
  6. Find and replace on all sheets
    By Cornwell in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-22-2010, 10:41 AM
  7. Find & Replace only specific data
    By Statsman in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-06-2008, 10:32 AM

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