Learn all type of Loops with small simple example

Here!

http://www.learn.net.au/vba/vba-loops

Thank you very much


Only following two didnt understand..
Sub LoopTime_Period() and Sub LoopTime_Count()

..and a word of caution. Learn about loops by all means. They have their uses. But don't get carried away with them.

With large ranges to process they can be very slow to process since the code has to jump backwards and forwards between the Excel Application and VBA with a time overhead each pass through the loop. And for many tasks they just aren't necessary. I've lost track of the number of times I see a looping procedure being recommended when the more elegant, simpler and quicker approach of using standard Data Filtering in a macro really is the best way to handle large ranges of data.

Totally agree with Richard Buttrey!

I was stuck up with Looping myself.. All my solutions used Loops, even when there were far better ways.

Loops are important, but there are other ways which should not be ignored..