title: Do until loop - until all the rows are empty
body: <p>I am not yet familiar with the VBA programming language and so far I can record and understand the macros, but making it myself is still quite difficult.</p>
  <p>I am currently working on a print template (worksheetname &quot;Horizontal&quot;). The template must be filled with information which it receives from the worksheet &quot;ZFA&quot;. After the template is filled it will print and empty it and delete the row from &quot;ZFA&quot;. As I have to do this task many times a day I wanted to know if there is a possiblity to do this via a loop. So repeat the upper steps until column c is empty in the worksheet &quot;ZFA&quot;.</p>
  <p>The code I'm now using for filling in the template, printing and deleting the row is:</p>
  <pre><code>Range(&quot;A2&quot;).Formula2R1C1 = &quot;=ZFA!RC&quot;
  ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
      IgnorePrintAreas:=False
  Range(&quot;A2&quot;).Select
  Selection.ClearContents
  Sheets(&quot;ZFA&quot;).Select
  Rows(&quot;2:2&quot;).Select
  Selection.Delete Shift:=xlUp
  Sheets(&quot;Horizontal&quot;).Select
  </code></pre>
  <p>So is it possible to repeat this task until column C in the worksheet ZFA is empty?</p>