find / findnext question

[Gary Keramidas]

i wrote some code to do a find and find next. i then wanted to use what i found
to find something else within the find / findnext loop. i get an error on the
loop line.

so, i'm guessing i can't use another find within a find / findnext, correct?

 

[Jim Thomlinson]

You are correct... Effectively you need to do a find repeatedly in your outer
loop as find next will use the parameters of the last find that was executed.

The other option would be to execute your entire find/findnext loop to
create a single large range object based on everything found. You can then
traverse through that range object and perform your find from there... If you
need a demo or some code just reply...

 

[Matt Richardson]

i wrote some code to do a find and find next. i then wanted to use what i found
to find something else within the find / findnext loop. i get an error on the
loop line.

so, i'm guessing i can't use another find within a find / findnext, correct?

Can you post your code so we can see and maybe fix your problem?

Regards,
Matt Richardson
http://teachr.blogspot.com

 

[Gary Keramidas]

thanks for confirming, jim.
--


Gary

You are correct... Effectively you need to do a find repeatedly in your outer
loop as find next will use the parameters of the last find that was executed.

The other option would be to execute your entire find/findnext loop to
create a single large range object based on everything found. You can then
traverse through that range object and perform your find from there... If you
need a demo or some code just reply...