Hi All,
My first post. I am new to VBA, and just learning.
I have find and replace complication which i am struggling to solve with a looping logic.
I have Data in column A, I then want to find and replace a certain part of a url in in the same row G:WV this certain part to find is referenced in cell F1 "REPLACE" throughout the entire worksheet
the replace data input in column A is distinctive for each row, and I need the macro to keep going to the next row and the next doing the same logical find replace until there are no more rows
I currently have this which only performs the task on one specified row, F1 is same for every row in the worksheet.
Range("G3:WV3").Select
Selection.Replace What:=Range("f1").Value, Replacement:=Range("A3").Value, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
My first post. I am new to VBA, and just learning.
I have find and replace complication which i am struggling to solve with a looping logic.
I have Data in column A, I then want to find and replace a certain part of a url in in the same row G:WV this certain part to find is referenced in cell F1 "REPLACE" throughout the entire worksheet
the replace data input in column A is distinctive for each row, and I need the macro to keep going to the next row and the next doing the same logical find replace until there are no more rows
I currently have this which only performs the task on one specified row, F1 is same for every row in the worksheet.
Range("G3:WV3").Select
Selection.Replace What:=Range("f1").Value, Replacement:=Range("A3").Value, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False