+ Reply to Thread
Results 1 to 6 of 6

Find/Replace Question

Hybrid View

  1. #1
    Forum Guru bakerman2's Avatar
    Join Date
    10-03-2012
    Location
    Antwerp, Belgium
    MS-Off Ver
    MSO Home and Business 2024
    Posts
    7,522

    Re: Find/Replace Question

    Let's start with this.

    Sub test1()
         
        For Counter = 2 To Range("B" & Rows.Count).End(xlUp).Row
             If Cells(Counter, 2) = "SALAME" Then Cells(Counter, 4) = Replace(Cells(Counter, 4), "AURORA ALIM.", "AURORA")
        Next
    
    End Sub
    Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
    You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  2. #2
    Registered User
    Join Date
    03-07-2017
    Location
    Brazil
    MS-Off Ver
    2010
    Posts
    7

    Re: Find/Replace Question

    Thank you bakerman2!!!

    It worked well

    Could you please explain me the code? I couldnīt understand well the Counter function..also why didnīt you use "End if"?

+ 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 Question
    By Canoga56 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 12-05-2014, 01:11 AM
  2. [SOLVED] Find, Replace question
    By JO505 in forum Excel General
    Replies: 23
    Last Post: 09-20-2014, 08:47 PM
  3. Find & Replace Question
    By johnysexcel in forum Excel General
    Replies: 5
    Last Post: 12-29-2010, 02:34 PM
  4. [SOLVED] Find & replace question.....I believe
    By anorton in forum Excel General
    Replies: 13
    Last Post: 06-04-2006, 08:30 AM
  5. Find and replace question
    By devens8765 in forum Excel General
    Replies: 8
    Last Post: 11-10-2005, 08:34 AM
  6. Find & Replace question
    By Stuart in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-28-2005, 03:06 PM
  7. Find/Replace Question
    By Littlebear in forum Excel General
    Replies: 3
    Last Post: 02-08-2005, 12:06 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