title: MS Excel - Paste a formula from a tab-delimited line
body: <p>I have a Visual Studio program that reads a PDF file and scrapes data from it. The VS program then generates a tab-delimited string that is manually pasted into the spreadsheet.
  Everything works fine, but my tab-delimited line erases a formula in one column.  Not a big deal as I just copy the formula from the previous line.</p>
  
  <p>Would it be possible to put the formula into my tab-delimited line?</p>
  
  <p>Here is the formula:</p>
  
  <pre><code>=IF(AND(NOT(ISBLANK($M2666)),ISBLANK($O2666)),"y","")
  </code></pre>
  
  <p>If I put this into the tab-delimited line in the appropriate column, it works fine, if I happen to be inserting the tab-delimited line on row 2666.</p>
  
  <p>I tried using the <code>row()</code> function, but then it's not a valid formula:</p>
  
  <pre><code>=IF(AND(NOT(ISBLANK($Mrow())),ISBLANK($Orow())),"y","")
  </code></pre>
  
  <p>I tried a function that returns the last row in a given column then made a variable to put into the formula. If I am just pasting in Excel, it works, but when I try to insert it in a tab-delimited line is pastes as text.</p>
  
  <p>Remember, the tab-delimited string is being generated in a program external to the spreadsheet and the program doesn't have access to the spreadsheet to find the last used row.</p>
  
  <p>So, here's the question, how do I paste a formula from the clipboard?</p>