I am having trouble grabbing the inner text (4.00% and 4.25%) from a web pages source code... Any help would be greatly appriciated...
Source Code:
VBA Coding:HTML Code:
![]()
Set Pelements = HTMLdoc.getElementsByTagName("P") Worksheets("WebData").Range("N2:N41").ClearContents r = 0 For Each Pelement In Pelements If Pelement.Style = "text-align: center;" Then Range("N2").Offset(r, 0).Value = Pelement.innerText r = r + 1 End If Next
Bookmarks