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
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.
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"?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks