Record extraction using VBA and web query

I need some help extracting a list from a webpage. I am using the following VBA code below. I've attached the worksheet to which it corresponds. This is the webpage I'm trying to pull from:
http://usabeachranking.com/jrranking...nder=1&Level=0

My problem is the website divides up all of the records in sets of 50 on different pages but uses the same URL. Therefore, my VBA code will only bring back the first 50 records for each group I am trying to extract.
Do you know how to pull all of the records for each URL? Please help!

Please Login or Register  to view this content.

hi doublea17, option, press Run button, hope this helps