Here is the full VBA. I keep recieving object required. Forgive me as I am new to VBA with HTML so I am learning the syntaxt of HTML. I assume, I am not hitting the HTML doc correctly. Tag vs ID?

Sub Macro2()
  Dim shellWins As ShellWindows
  Dim IE As InternetExplorer
  Dim sIEURL As String
  Dim ACCURL As String
Dim ROWNUM As String
  
  Set shellWins = New ShellWindows
  Set IE = shellWins.Item(0)

ROWNUM = 2

Do While Cells(ROWNUM, 1).Value <> ""

ACCURL = "WEB ADDRESS" & Range("A" & ROWNUM).Value & "#tab9"

sIEURL = IE.LocationURL

IE.Navigate ACCURL
'wait until the page loads
 Do While IE.Busy Or IE.ReadyState <> READYSTATE_COMPLETE
 DoEvents
 Loop

IE.Document.getElementById("investmentCharlesCode")(0).getElementsByClassName("Value")(1).Text

ROWNUM = ROWNUM + 1

Loop

  Set shellWins = Nothing
  Set IE = Nothing
MsgBox "Completed Account List"
End Sub