How do i create a loop on a macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

There are many ways: Do...Loop, For...Next, For Each...Next,
While...Wend, etc.

Check out the "looping through code" item in XL Help.


In article ,
Stu wrote:

How do i create a loop on a macro?

for each c in range("a1:a21")
msgbox c.value
next

"Stu" wrote in message
...
How do i create a loop on a macro?

Thanks



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Here's a WebPage that shows the variety of looping structures.

http://support.microsoft.com/default...1%2Fvbc5-4.asp

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------
How do i create a loop on a macro?