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?