title: Find first non-empty cell
body: <p>Hey everyone I've been trying to figure this one out, but I can't seem to get it to work. It probably has a really simple answer though. </p>
  
  <p>So this has to be done as a macro because it is a part of a much larger program. </p>
  
  <p>What I am trying to do is find a cell that has any value in it. Meaning it can be any word, number, or symbol. Non-blank if you will.</p>
  
  <p>This is what I am currently using:</p>
  
  <blockquote>
    <p>Column D<br>
    1<br>
    (blank)<br>
    (blank)<br>
    123</p>
  </blockquote>
  
  <p>Macro:</p>
  
  <pre><code>Columns("D").Find("*", Cells(Rows.Count, "D")).Select
  </code></pre>
  
  <p>and what is happening is that it loops back skipping the two blanks and the 123 then goes back to the 1.</p>
  
  <p>Any help would be appreciated and if there are other suggestions they would be welcomed.</p>