Hi,
I need to replace some data in certain cells but my current code won't work;
I'm trying to replace $G with $J just in cells H12 to K23??![]()
With Sheets("Reconciliation") .Cells("H12:K23").Replace What:="$G", replacement:="$J", LookAt:=xlPart, SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False End With
Any ideas?
Bookmarks