Hi Makeshft,
Welcome to the forum.
Getting HTML info can be tricky. You need to delve into the page to understand its structure to get the right information back. In your case the information you really need is in the element after that whose className = "persondata-label". The following should produce a Table with the information that you want.
Dim URL As String Dim IE As InternetExplorer Dim HTMLdoc As HTMLDocument Dim TDelements As IHTMLElementCollection Dim TDelement As HTMLTableCell Dim r As Long Dim bGetNext As Boolean 'Saved from www vbaexpress com/forum/forumdisplay.php?f=17 URL = "h**p://en.wikipedia.org/wiki/Rihanna" 'change the ** to tt Set IE = New InternetExplorer With IE .navigate URL .Visible = False 'Wait for page to load While .Busy Or .readyState <> READYSTATE_COMPLETE: DoEvents: Wend Set HTMLdoc = .document End With Set TDelements = HTMLdoc.getElementsByTagName("TD") r = 0 For Each TDelement In TDelements If bGetNext Then Sheet1.Range("A1").Offset(r - 1, 1).Value = TDelement.innerText bGetNext = False End If 'Look for required TD elements - this check is specific to VBA Express forum - modify as required 'Debug.Print TDelement.className '- useful for inspecting the HTML info If TDelement.className = "persondata-label" Then Sheet1.Range("A1").Offset(r, 0).Value = TDelement.innerText bGetNext = True 'Trigger to get the information from the next TDelement r = r + 1 End If Next IE.Quit End Sub
Hope this helps.