C
Christine
Hello,
Thanks in advance for your insight.
I need to run a loop that finds the value of a cell, takes
that value, and searches for it in another sheet. I have
pretty limited knowledge of VBA so I created a macro, but
when I look at the code, it has the actual value for what
it is searching for. This value will change and I don't
want to use that value only. So how can I tell it that
whatever value it finds, to do a search on that?
Am I making any sense? In the "What:=" part, I want it to
find whatever value the previous code has selected, not
just "MI071001".
Here is the code:
Selection.Find(What:="MI071001", After:=ActiveCell,
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows,
SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Please let me know if you have questions. Your help is
definitely appreciated.
Christine
Thanks in advance for your insight.
I need to run a loop that finds the value of a cell, takes
that value, and searches for it in another sheet. I have
pretty limited knowledge of VBA so I created a macro, but
when I look at the code, it has the actual value for what
it is searching for. This value will change and I don't
want to use that value only. So how can I tell it that
whatever value it finds, to do a search on that?
Am I making any sense? In the "What:=" part, I want it to
find whatever value the previous code has selected, not
just "MI071001".
Here is the code:
Selection.Find(What:="MI071001", After:=ActiveCell,
LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows,
SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
Please let me know if you have questions. Your help is
definitely appreciated.
Christine