This video explains how to write Do While and Do Until loops in Excel VBA. The example given archives records by moving records that relate to a date in the past to another worksheet.
------------------------