+ Reply to Thread
Results 1 to 3 of 3

VBA Find and Replace Using Cell Contents

  1. #1
    Registered User
    Join Date
    03-30-2014
    Location
    Glendale, Arizona
    MS-Off Ver
    Excel 2013
    Posts
    25

    VBA Find and Replace Using Cell Contents

    Hi All,

    I am trying to find a way to VBA what the Excel 2010 Find and Replace performs.

    I can select the range that I want to have the replacements made using Range.("My Range").Select - no problems
    I do want the FIND information to be from a specific cell named "FINDTHIS" and the REPLACE WITH information to be from a specific cell named "REPLACEWITHTHIS".
    The information in the two named cells changes based on other cells in the worksheet. Further, the information in these two cells are not a formulas but rather strings.

    I have tried the macro recorder copying in the cells during the recording process but the macro hard codes the data for the FIND and REPLACE text with whatever text you are using at the time of the recording and skips the copying in process.

    Any ideas?

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,967

    Re: VBA Find and Replace Using Cell Contents

    Maybe

    Please Login or Register  to view this content.
    Martin

  3. #3
    Registered User
    Join Date
    03-30-2014
    Location
    Glendale, Arizona
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: VBA Find and Replace Using Cell Contents

    Shazzamm! You're the boss. I bow before you. Why that isn't easy to find somewhere, I'll never know.
    Thanks!
    Last edited by DMumme; 05-10-2014 at 10:27 AM. Reason: [SOLVED]

+ 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 using cell contents as the search criteria
    By Vlad717 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-08-2013, 03:58 PM
  2. Find & Replace Entire Cell Contents
    By dwhite30518 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2013, 12:39 AM
  3. Find and replace a character with another cell contents
    By tcapewell in forum Excel General
    Replies: 4
    Last Post: 07-12-2010, 10:23 AM
  4. Find and replace with contents of a cell
    By gettingthere in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-27-2009, 03:24 PM
  5. Using Find/Replace to delete contents of cell
    By richardeallen in forum Excel General
    Replies: 1
    Last Post: 11-30-2006, 07:17 AM

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