title: Size of Table Range on Visual Basic ( Excel )
body: <p>i'm a beginner on Visual studio for Excel.
  I have a prob with the size of Table</p>
  
  <p>I use this code : </p>
  
  <pre><code>Sub Comparaison()
  Dim sheet1 As Worksheet
  Set sheet1 = Sheets("feuil1")
  Dim Tableau_dataBase ()
  Tableau_dataBase = Range("B3:D8")
  MsgBox " Size of table" &amp; Tableau_dataBase.Height // error
  MsgBox " Size of table" &amp; Tableau_dataBase.Length // error
  
  End Sub
  </code></pre>
  
  <p>My table on Excel ( only string) :</p>
  
  <p>7   data1   data2 </p>
  
  <p>43  data1   data2</p>
  
  <p>8   data1   data2</p>
  
  <p>But I have an error 
  How can I know the size of this table ?</p>
  
  <p>thanks</p>