title: Excel Macro in VBA - How to apply a loop to move down columns
body: <p>I have a sub Macro that basically works as a currency converter that allows the user to define their own exchange rate values. I have tested it on one cell and works fine but I need it to loop and move down a row for a define range. (Currently the cells defined are L2, K2 and G", need to to repeat on L3, K3 and G3 until Ln, Kn and Gn etc.)</p>
  
  <p>Code is as follows:</p>
  
  <pre><code>Sub Macro9()
  '
  ' Macro9 Macro
  '
  
  Dim score As String, result As String
  score = Sheets("Paste Orders Here").Range("K2").Value
  
  If score = "USD" Then
      result = Sheets("Paste Orders Here").Range("L2") * Sheets("Configuration").Range("C5")
  ElseIf score = "EUR" Then
      result = Sheets("Paste Orders Here").Range("L2") * Sheets("Configuration").Range("B5")
  ElseIf score = "GBP" Then
      result = Sheets("Paste Orders Here").Range("L2")
  ElseIf score = "" Then
      result = Sheets("Paste Orders Here").Range("K2")
  End If
  
  Sheets("Brightpearl").Range("G2").Value = result
  '
  End Sub
  </code></pre>
  
  <p>Thanks, I understand this could be completely incorrect for wanting to apply this to multiple rows but I could really use some help!</p>