I have this code recorded by XL. Works ok.
Cells.Find(What:="dd", After:=ActiveCell, LookIn:=xlFormulas, LookAt:= _
xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:=False) _
In the first part - (What="dd",
I want the macro to read Cell G1 and looks for text that is in that cell.. G1 changes often.