vba macro for search and replace

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: vba macro for search and replace

  1. #1
    New Member
    Join Date
    May 2003
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default vba macro for search and replace

     
    Hi folks,

    I need to creat a makro to search and replace several "x" in a colum and change it into "n.m.". This in 'bout 20 different workbooks.

    therefore i like to create a makro that goes for a range, search the "x" and replaces it with "n.m."

    does someone has a idee how i can put "search and replace" into a vba code?

    greetz

    Mike

  2. #2
    MrExcel MVP
    Moderator
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    42,694
    Post Thanks / Like
    Mentioned
    16 Post(s)
    Tagged
    2 Thread(s)

    Default Re: vba macro for search and replace

      
    WELCOME TO THE BOARD!

    The best way to do these sort of things is to use the macro recorder and actually record your steps. Then you can modify the code to suit your needs. The macro recorder is found under Tools | Macro | Record New Macro.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com