title: Trouble with formular1c1 in Excel 2010
body: <p>I am working on learning Excel while modifying some code, and have a question. The code works, but I am having trouble understanding how or why. I understand most of what the code is doing, but there is one section I am having trouble with understanding.</p>
  
  <p>Here is the code:</p>
  
  <pre><code>Range("A3:A8").FormulaR1C1 = "=IF(RC[6]=""MSH"", R[1]C[1],R[-1]C)"
  </code></pre>
  
  <p>Now, I understand most of what it is doing. What is confusing me, is what exactly the R[-1]C is doing. It seems like it is saving the value of the cell from the first test and passing it to the rest of the range of cells. I guess my question is how or why. It seems to me that it would run the test on each cell in the range, but that's not happening.</p>
  
  <p>Any help is appreciated.</p>
  
  <p>Thanks
  Mike</p>