+ Reply to Thread
Results 1 to 2 of 2

VBA to find and replace from a table in excel 2013

  1. #1
    Forum Contributor
    Join Date
    08-15-2015
    Location
    India
    MS-Off Ver
    Office 2016
    Posts
    221

    VBA to find and replace from a table in excel 2013

    Hi, i have created a table in excel where all my words in english are in column A in sheet "language master", column B has its corresponding words in other language.The name of the table is "Table7"
    I am trying to make a macro which finds the words in english in the entire workbook excluding "Language Master", and replaces it with its corresponding word from column B.
    my code so far is as follows but is not working.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: VBA to find and replace from a table in excel 2013

    Maybe:

    Please Login or Register  to view this content.
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

+ 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. Excel 2013 delete and replace a macro
    By Arismac in forum Excel General
    Replies: 2
    Last Post: 02-17-2016, 06:30 AM
  2. Excel 2013 and Access 2013 as Pivot Table External Data Source
    By Grimnebulin in forum Access Tables & Databases
    Replies: 1
    Last Post: 05-27-2015, 02:13 PM
  3. Replies: 3
    Last Post: 11-25-2014, 06:08 AM
  4. [SOLVED] Excel 2013 - VBA Find and Replace
    By colbyski90 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-12-2014, 09:51 AM
  5. Code for find an replace (word 2013)
    By capitala in forum Word Programming / VBA / Macros
    Replies: 1
    Last Post: 02-03-2014, 06:57 AM
  6. find in excel replace in word: find/replace text in text boxes and headers
    By dean.rogers in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2012, 12:40 PM
  7. Find/Replace Macro Using Replace Table
    By LampCommandr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-24-2011, 11:00 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