title: Last not empty cell (column) in the given row; Excel VBA
body: <p>I have an excel sheet in which I need to find the last <em>non empty cell</em> in a specific row.</p>
  
  <p>How do I do this?</p>
  
  <p>The below will select this for me, but it will select the <em>first</em> not empty cell, I need the last not empty cell in the row #29.</p>
  
  <p><code>Worksheets("DTCs").Range("A29").End(xlToRight).Select</code></p>