title: Find name of the last cell with data in a row
body: <p>I've searched for an answer, but it seems that I can only find VBA-based solutions, which appear no longer be an option in Excel 2008.  </p>
  
  <p>I'm trying to return the name of the last cell in a row that contains data. It looks like this:</p>
  
  <pre><code>+===========================================================+
                   A      /  B  /  C  /  D  /  E  (columns)
  +===========================================================+
  1         || [Formula] /  3  /  4  /  5  / [blank]
  2         || [Formula] /  7  /  8  / [blank] / [blank]
  3         || [Formula] /  9  / 10 / 11 / 12
  (rows)
  +===========================================================+
  </code></pre>
  
  <p>and the end result would look like this:</p>
  
  <pre><code>+===========================================================+
               A   /  B  /  C  /  D  /  E  (columns)
  +===========================================================+
  1         || D1 /  3  /  4  /  5  / 
  2         || C2 /  7  /  8  /     / 
  3         || E3 /  9  / 10 / 11 / 12
  (rows)
  +===========================================================+
  </code></pre>