webbynet
07-10-2010, 05:10 PM
I am trying to use a find within a Macro but the issue is that my find will constantly change. I have the following example code:
SearchItem = Range("K1")
Columns("J:J").Select
Selection.find(What:=SearchItem, After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
Once I have activated I may want to remove the entire row so the value in cell K1 will change and the new value in K1 is what I would then want to find.
Thank you for your help
SearchItem = Range("K1")
Columns("J:J").Select
Selection.find(What:=SearchItem, After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
Once I have activated I may want to remove the entire row so the value in cell K1 will change and the new value in K1 is what I would then want to find.
Thank you for your help