As a quick fix in a larger macro I am trying to replace the carried over "=#REF!*F and its its row number" with "D and its row number * F and and its row number"
I tried this but it gives a static reference to whatever cell is selected at the time
With Worksheets(2)
LastRow = .Range("g" & Rows.Count).End(xlUp).Row
Dim Findtext As String, Replacetext As String
Findtext = "#REF!"
Replacetext = "d" & Selection.Row ' does not give me the actual cells row number
Columns("g8:g" & LastRow).Replace what:=Findtext, replacement:=Replacetext, lookat:=xlPart, MatchCase:=True
End With
Any help appreciated
Bookmarks