myPoints is holding an array, therefore you will not be able to use "myPoints.innerText"

In my original code:
 
For x = 1 To myPoints.Length    
    Sheet1.Range("A" & x).Value = myPoints(x - 1).innerText
Next x


"myPoints(x - 1).innerText" needs to have the number in brackets in order to work.

"Doc.getElementsByClassName("price-per-sellable-unit")" contains every "price-per-sellable-unit" loaded on that page.

"myPoints.Length" counts how many "price-per-sellable-unit" there are in myPoints.

This is why we have the loop "For x = 1 To myPoints.Length"

You may also need to change pages and load the next set of "price-per-sellable-unit"

Worth noting that web scraping is tricky and can be unreliable in the sense that these websites do get updated regularly and can cause issues with your code.

Hope this helps