title: Passing cell references to spreadsheet functions
body: <p>When I call a spreadsheet function, say <code>int(f2)</code>, the function operates on the value in the cell. If <code>cell("F2")</code> contains 3.14159, the result would be 3.
  But when I call a different type of function — for example: <code>row(f8)</code> — the function takes the cell reference, and not the value, in this case, returning 8.</p>
  
  <p>How do I get my custom function to work with the reference, rather than the value?</p>
  
  <p>I can pass a string, and use <code>getRange()</code>, but, if I move or update the cells on the sheet, the strings won't change.</p>
  
  <p>Really simple example:</p>
  
  <pre><code>function GetFormula(cellname) {
    return SpreadsheetApp.getActiveSheet().getRange(cellname).getFormula();
  }
  </code></pre>
  
  <p>With this in my sheet's code, I can retrieve the formula in C4 like this: <code>=GetFormula("C4")</code></p>
  
  <p>But, this argument is a string, and I would rather pass a cell reference. A somewhat more complicated issue requires the calling cells to update when copied and pasted.</p>
  
  <p>Any ideas?</p>