title: VBA locate the first empty cell that occurs in a row by moving left/right
body: <p>I have a <code>Row</code> in <code>Excel</code> and many cells of that row are populated by numbers, dates, etc. </p>
  
  <p>Let us say this is <code>Row 1</code>. However once we make a couple of moves in <code>Row 1</code> to the left we find 3 or 4 empty cells and then continuing our move to the left on <code>Row 1</code> the cells are populated again by various values.</p>
  
  <p><strong>How can i go to the first cell which is blank and empty that occurs, when we move to the left in <code>Row 1</code> every time i fire up a macro?</strong></p>
  
  <pre><code>.____.____.___.___.___.____.____.____.____.____.
  |_d__|_d__|___|___|___|__x_|_d__|_d__|_d__|_O__|
  </code></pre>
  
  <p>To put this schematicall <strong>if we are</strong> on <code>O</code> how can we <strong>find/go</strong> to <code>x</code>?</p>
  
  <p>(Lets assume the <code>x</code> is the first blank cell)</p>
  
  <p>How can i go here
  <img src="https://i.stack.imgur.com/Avtiv.png" alt="enter image description here"></p>