loop?

[Stu]

How do i create a loop on a macro?

Thanks

 

[J.E. McGimpsey]

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

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

 

[Don Guillett]

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

 

[pfsardella]

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

http://support.microsoft.com/default.aspx?scid=/support/excel/content/vba101/vbc5-4.asp

HTH
Paul