View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default find / findnext question

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...
--
HTH...

Jim Thomlinson


"Gary Keramidas" wrote:

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?

--


Gary