View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default find / findnext question


thanks for confirming, jim.
--


Gary


"Jim Thomlinson" wrote in message
...
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