title: VBA Webscrape HTML Coinmarketcap
body: <p>Trying to scrape the number of cryptos in the top left corner of <a href="https://coinmarketcap.com/" rel="nofollow noreferrer">https://coinmarketcap.com/</a>. I tried to find the &quot;tr&quot; but could not. Not sure how to grab that value up the top left of the page.</p>
  <p>Here is what I have so far and I am being thrown a runtime error 438 Object doesn't support this property or method.</p>
  <pre><code> Sub cRYP()
  
   Dim appIE As Object
   Set appIE = CreateObject(&quot;internetexplorer.application&quot;)
  
    With appIE
    .Navigate &quot;https://coinmarketcap.com/&quot;
    .Visible = True
   End With
  
   Do While appIE.Busy
   DoEvents
   Loop
   Set allRowOfData = appIE.Document.getElementById(&quot;__next&quot;)
  
    Dim myValue As String: myValue = 
    allRowOfData.Cells(16).innerHTML
  
    appIE.Quit
  
    Range(&quot;A1&quot;).Value = myValue
  
    End Sub
  </code></pre>