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.
June 12, 2009 6:18 AM
June 12, 2009 12:45 PM