title: How to find RowCount of a table which pasted from web to excel
body: <p>im recieving a table from web in excel with the code below</p>
  
  <pre><code>With ActiveSheet.QueryTables.Add(Connection:= _
      "URL;some url")
      .WebSelectionType = "xlSpecifiedTables"
      .WebTables = "10"
      .BackgroundQuery = True
      .TablesOnlyFromHTML = True
      .Refresh BackgroundQuery:=False
      .SaveData = True
  End With
  </code></pre>
  
  <p>but also i wanna get the row count from that table i got.
  so how can i achive that?</p>
  
  <pre><code>With ActiveSheet.QueryTables.Add(Connection:= _
      "URL;some url")
      .LineCount 'is it smt like this???????
  End With
  </code></pre>