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?