title: Excel / VBA last row/column
body: <p>I need to copy paste big sheets, this is taking a lots of time.
  I have been advised not to use .copy process on worksheets but rather proceeds cell by cell. Giving new cells each properties of the ancient cell.  This is what I do here: <a href="https://stackoverflow.com/questions/16277601/saving-only-some-sheets-in-another-workbook/16305865?noredirect=1#16305865">Saving only some sheets in another Workbook</a>.</p>
  
  <p>To do it cells by cells I need to know the last cell containing information. (not only value, but colour, borders... etc). I've seen many simple solution on internet, but they all have a problem. </p>
  
  <p>ActiveSheet.UsedRange.Rows.Count often gives too many values... I got a 810 * 16000 answer for a 5 * 18 table</p>
  
  <p>range("A" &amp; activesheet.rows.count).end(xlup).row works only for the first columns...</p>
  
  <p>What would be the best way to procedd to final the real last line with value ? containig information (value, colour, border...)</p>