Proper syntax to make macro repeat

Hello everyone

I'd like your help with making this macro repeat.

About the Macro:

There are 2 worksheets in the same workbook.

Sheet 1 is titled "Letter"
Sheet 2 is titled "Nov '14 to Nov '15 Customers"

What this macro does is:

1. "Quick Print" sheet 1
2. Change cell A2 on Sheet 2, from "No" to "Yes" (Column A is titled "Printed")
3. Sort Sheet 2 starting with row 2, first by column A ("Printed"), then by column Column C ("Name") smallest to largest, so that the "Yes" cells are at the bottom and the list remains in alphabetical order, meaning everything prints in alphabetical order.

I would like this macro to repeat until all rows show they've been printed (currently a little more than 2,600 rows).

Macro Code

Here's the Macro I created using the Excel interface (Record Macro, do the steps, stop recording). It works - but I don't know how to make it repeat. Thank you in advance for your time and assistance!

Please Login or Register  to view this content.

Maybe ...

Please Login or Register  to view this content.

You're welcome.