For type loop verse Do type loop

I have been a member of this list for less than a month, but I have noticed in several posts that several seem to favor a For type loop over the Do type loop. Most of my programs are used to perform a variety of procedures on big lists of students so I am normally using Do While Len(student id) <> 0.

Would a For type loop be a better option in my given situation? Is there any particular advantage to using a For loop as opposed to a Do loop?

Thanks for the input!

Jeff

Hello Jeff, I probably am not the best one to answer this but: A FOR loop is set on the amount of times that you want it to run, where as a DO loop is looking for a condition to be met.

Hope it helps

mudraker,

Thanks for the additional response concerning For and Do type loops. Checking memory as opposed to a cell value would be quicker so I can see how a For loop might make my sub run a little faster than the Do loop.

I also got the message concerning posting back to the thread instead of using the PM feature. I will do that in the future!

Thanks for all the help!

Jeff