title: Access cells in other file with variable
body: <p>I'm taking info from one file to another, using: (<strong>7.xlsx</strong> is the file name)</p>
  
  <pre><code>Cells(13, 4).Select
  ActiveCell.FormulaR1C1 = "=[7.xlsx]sheet1!R3C5"
  </code></pre>
  
  <p>In this situation, I am taking the information from C5 spot. <em>But</em> I want to take the info not from this spot only, but from different spots, using loop.</p>
  
  <pre><code>Dim i As Integer
  For i = 3 To 17
      Cells(i, 4).Select // works fine
      ActiveCell.FormulaR1C1 = "=[7.xlsx]sheet1!R3C5" // I want to put the
                                                     // "i" instead of the C
  </code></pre>
  
  <p>Any idea how I can do it?<br>
  Thanks in advance!</p>