Sheets("217").Range("$G$2:$G" & LastRow).Select
Selection.Replace What:="", Replacement:=Cells(Active.row, 6).Value, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
I am trying to find and replace the currently selected cell value with that of another cell on the same current row.
I have added the code that I thought would work but it hasn't. Anyone got any ideas on how I could go about doing this?