Set ActiveCell

[kckay]

I am doing a search of a value; once found, I need to search a different value AFTER the cell result of the first search.

How do I set the .find command to deal with this?

After:=(previous found field) ?
After:=ActiveCell ?

If ActiveCell, how do I set the result of the previous search to be the ActiveCell?

 

[VoG]

Take a look at the FindNext method. The Help gives a good example.

 

[Weaver]

It might be worthwhile posting your code. With the use of 'activecell', I'm guessing you're using select, which you may not need to do.

for instance

set f = cells.find(what:="my_criteria")
set g = cells.find(what:="my_other_criteria",after:=f)

Findnext would be useful if you're looking for the same thing after your first search, but your question suggests that isn't the case.

 

[kckay]

The way I understand the .FindNext is it will search for the same parameters as the original .Find. I am looking to search for a different value than the original .Find parameters - starting from where the original .Find resulting cell was located.

 

[Weaver]

The way I understand the .FindNext is it will search for the same parameters as the original .Find. I am looking to search for a different value than the original .Find parameters - starting from where the original .Find resulting cell was located.

Have you read post #3?

 

[kckay]

Weaver, cool info. I hacked my way through, but know my solution is not elegant. I will try modifying to what you show. I was replying to the second post when you posted.