Web Scraping with VBA
I can only point out cosmetic issues (I don't know sqat about VBA),
I hope another reviewer will pass by and cover other aspects.

Unused variables

These variables seem to be unused, so why not remove them:

Dim selection As Object
Dim bookmark As String
Dim test As String
Dim pageLoading As Boolean


Magic string

This string appears twice:


"http://www.albumoftheyear.org/ratings/6-highest-rated/"



It would be better to define it one place, so you can change it one place if needed.

Readability

This block:


aotyYear = InputBox("Input the year you're scraping")
If aotyYear &lt; 1900 Then Exit Sub
url = "http://www.albumoftheyear.org/ratings/6-highest-rated/" &amp; aotyYear &amp; "/1"
Set sheet = ThisWorkbook.Worksheets("ScrapeSheet")
row = 2
exitFlag = False
page = 1



Would be more readable if you break a line after the early return:

aotyYear = InputBox("Input the year you're scraping")
If aotyYear &lt; 1900 Then Exit Sub

url = "http://www.albumoftheyear.org/ratings/6-highest-rated/" &amp; aotyYear &amp; "/1"
Set sheet = ThisWorkbook.Worksheets("ScrapeSheet")
row = 2
exitFlag = False
page = 1




It might be a matter of taste,
but I think this would be more readable if the condition was not split,
on a single line.


    If nextPage.Length = 2 _
    Or nextPage(0).innerText = "Next &gt;" Then
        page = page + 1
    Else
        exitFlag = True
    End If