Fotodj,
This may not be the ideal solution since it is quite static in where it looks for the search result, but with current page layout seems to work. It might technically be better to loop through each row/cell of the table, look for your search value and then get the 2nd cell after that. However, try this simpler code below. Note I added a 5 second pause... you may or may not need it, but for some reason I kept getting an error even though IE.ReadyState was 4, and not busy.... It still couldn't find the object until I added the delay. This code would go after your for loop.
Do While ie.readyState <> 4 Or ie.busy: DoEvents: Loop
'now even though not busy and readystate = 4 I still get an error for some reason, but adding the delay below solved that
Application.Wait (Now + TimeValue("0:00:05"))
Sheets("Scramble").Range("B2").Value = ie.document.getElementsByClassName("ScrambleLabel")(11).innerText
Bookmarks