Results 1 to 7 of 7

VBA Replace from Cells

Threaded View

  1. #1
    Registered User
    Join Date
    06-28-2006
    Posts
    46

    Question VBA Replace from Cells

    Hello,

    I have a list of strings to find (what) and replace (replacement), in sheet 1 column A & B:

    string to search | replace with
    apple | green apple
    pear | snow pear
    grape | red grape

    How can I configure the Replace function to use this sheet as the source for What and Replacement?

    Something in the like of:

    Replace What:=A2, Replacement:=B2, LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False


    Many thanks!
    Last edited by duration; 06-27-2014 at 05:27 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Replace blank cells with ZERO using Find Replace
    By makinmomb in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2014, 04:47 PM
  2. Formula: Drop Down List -> Choose Option Finds Cells & Replace Cells with Cells
    By g00glethis1 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-14-2010, 01:10 PM
  3. Find, and replace but copy cells before replace
    By raehippychick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2007, 08:16 AM
  4. Checking the Cells in Sheet1 with Cells in Sheet2 and replace
    By Checking the cells in Sheet1 with Sheet2 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-19-2006, 04:29 AM
  5. How to find multiple cells/replace whole cells w/data
    By dcurylo in forum Excel General
    Replies: 2
    Last Post: 11-30-2005, 04:10 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