title: Nested looping and combinations
body: <p>I have this question:</p>
  
  <p>Create a Sub with any combination of nested loops. This nested loop should take the baby girl names input (below) and print out every possible combination. These input names will need to appear in your workbook somewhere. Print out the combinations in the workbook itself.</p>
  
  <p>Input<br>
  <a href="https://i.stack.imgur.com/JNohx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JNohx.png" alt="names"></a></p>
  
  <p>I have been able to get Penelope paired with all the middle names, but I can't figure out how to pair the rest of the first names. I don't know how to offset the active cell to the second first name and so on. this is what I have so far:</p>
  
  <pre><code>Sub part2()
      Dim combination As String
      Dim fName As String
      Dim mName As String
  
      Range("A1").Activate
      fName = ActiveCell.Value
  
      Do Until IsEmpty(ActiveCell)
          mName = ActiveCell.Offset(0, 1).Value
          combination = fName &amp; " " &amp; mName
          ActiveCell.Offset(0, 3) = combination
          ActiveCell.Offset(1, 0).Activate
      Loop
  </code></pre>