View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default use different string variables in FOR loop

More details about what you plan to do with the items as you loop through
them would be helpful. If, for example, you are just trying to see if one
the loop-items is equal to some other variable's content, you may not need
to use a loop at all. As with all programming, the code approach you would
use to solve the problem depends on what the problem you are trying to solve
is... if you don't tells us what that is, we could guess forever and never
get it right.

--
Rick (MVP - Excel)


"John Keith" wrote in message
...
I would like to create a FOR loop that uses many different string
values as the loop variable, maybe 20-30 different values.

What kind of structure is required to loop through a list of string
varibles like this:

red
green
blue
orange
and so on....

Thanks


John Keith