title: VBA return next value from for loop
body: <p>I need to populate a cell with each value from a <code>For</code> loop.  I have a worksheet with Employee Names and Employee IDs.  I am attempting to populate cells on another worksheet and print to default printer (or PDF preferred), then do the same for the next employee in the list.</p>
  
  <p>Any help is greatly appreciated.  What I currently have only returns the first employee name and no ID.</p>
  
  <pre><code>Sub btn_CompleteForm()
  
  Dim Rng As Range, cell As Range, EmpName As Range
  Set NameRng = Range("Employees!A2:Employees!A10")
  Set IDRng = Range("Employees!B2:Employees!B10")
  Set EmpName = Range("ActionNotice!D7")
  Set EmpID = Range("ActionNotice!D8")
  
  For Each cell In NameRng
      EmpName = NameRng.Value
      EmpID = IDRng.Value
      ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
          IgnorePrintAreas:=False
      MsgBox "Next"
  Next cell
  
  End Sub
  </code></pre>