title: Last Used Cell in sheet
body: <p>I'm new here and I'm looking to use Excel VBA to return the last used cell in a worksheet.</p>
  <p>I'vv looked at <a href="https://stackoverflow.com/questions/11169445/error-in-finding-last-used-cell-in-vba">Error in finding last used cell in Excel with VBA</a>) but that didn't answer the two problems I have:</p>
  <ol>
  <li><p>The <code>.Cells.Find(...).Row</code> method takes WAY too long in my code.</p>
  </li>
  <li><p>My meaning of &quot;last used cell&quot; might be odd...the cell can be blank. I want to take the column that has the last used cell and pair it with the row that has the last used cell.</p>
  </li>
  </ol>
  <p>To explain: Assume a sheet is empty except for data in <code>A1:C3</code>, <code>D2</code> and <code>B4</code>. (<a href="https://i.stack.imgur.com/Eg7vU.png" rel="nofollow noreferrer">Exhibit 1</a>)</p>
  <p>The last cell I'm interested in is <code>D4</code>because I want the last cell in the sheet that includes all data in the sheet.</p>
  <p><a href="https://i.stack.imgur.com/Eg7vU.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Eg7vU.png" alt="enter image description here" /></a></p>
  <p>Now that I've explained what I'm looking for, can anyone provide suggestions as to either</p>
  <ul>
  <li>how to make cells.find run faster or</li>
  <li>another credible method to find the &quot;last cell&quot; in a worksheet?</li>
  </ul>
  <p>Thank you!</p>