title: lastrow and excel table.
body: <p>I have tried to define a lastrow code that would return the last row value of the last non empty cell in a excel table. (ITS FORMATTED AS A TABLE)</p>
  
  <p>My exceltable have values in COL A from 1 to 1005, COL B from 1 to 414 and in COL C from 414 to 1005. </p>
  
  <p>What i want is to have one lastrow code that returns 414 and one that returns 1005. The problem i get is that because it is in a table. my codes</p>
  
  <pre><code>        lastrow3 = ThisWorkbook.Worksheets("DataÖnskemål").Range("A" &amp; Rows.Count).End(xlUp).Row
          lastrow2 = ThisWorkbook.Worksheets("DataÖnskemål").Range("B" &amp; Rows.Count).End(xlUp).Row
  </code></pre>
  
  <p>Both return 1005. Can i get around this with my table or is it a formating issue of some sort?</p>
  
  <p>Best regards and thanks in advance
  /D</p>