title: Better way to find last used row
body: <p>I am trying to find the last row the same way I found the last column:</p>
  <pre><code>Sheets(&quot;Sheet2&quot;).Cells(1,Sheets(&quot;Sheet2&quot;).Columns.Count).End(xlToLeft).Column
  </code></pre>
  <p>I know this way but it is not as helpful as the prior would be:</p>
  <pre><code>u = Sheets(&quot;Sheet1&quot;).Range(&quot;A65536&quot;).End(xlUp).Row
  </code></pre>
  <p>I tried:</p>
  <pre><code>Sheets(&quot;Sheet2&quot;).Cells(Sheets(&quot;Sheet2&quot;,1).Rowa.Count).End(xlToUP).Column
  </code></pre>
  <p>Synopsis: I would like the below way for last row.</p>
  <pre><code>Sheets(&quot;Sheet2&quot;).Cells(1,Sheets(&quot;Sheet2&quot;).Columns.Count).End(xlToLeft).Column
  </code></pre>