title: Scraping all pages of a paginated site in Excel using VBA
body: <p>I'm trying to scrape web data from a county website using VBA in Excel 2013.  I'm new to this, and feel like my code isn't even worth posting, but I was hoping that I could get some help with my general approach.  </p>
  
  <p>A sample search term has led me to the <a href="https://pa_allegheny.uslandrecords.com/palr/controller?commandflag=searchByNameID&amp;optflag=SearchCommand&amp;county=pa003&amp;userid=null&amp;userCategory=7&amp;nameid=935708&amp;partytype=&amp;name=UNIVERSITY%2BPGH%2BTHE%2BCOMWTH%2BSYSTEM%2BHIGHER%2BEDUCATION&amp;officeid=60&amp;fromdate=01/01/1986&amp;todate=04/14/2015&amp;lastname=university">following URL</a></p>
  
  <p>If I click "Next", it takes me <a href="https://pa_allegheny.uslandrecords.com/palr/controller?commandflag=searchByNameID&amp;optflag=SearchCommand&amp;county=pa003&amp;userid=null&amp;userCategory=7&amp;nameid=935708&amp;startrow=21&amp;startpage=1&amp;lastpage=10&amp;partytype=&amp;name=UNIVERSITY%2BPGH%2BTHE%2BCOMWTH%2BSYSTEM%2BHIGHER%2BEDUCATION&amp;officeid=60&amp;fromdate=01/01/1986&amp;todate=04/14/2015&amp;lastname=university">here</a> </p>
  
  <p>I am limited to 20 search results at a time, and it looks like the "Next" button will take me to a similar URL, but with the "&amp;startrow=" parameter set to 20 greater than the previous page.  </p>
  
  <p>If I want to copy all of the data from all pages, do I need to focus on "&amp;startrow=" in order to properly loop?  And if so, what's the best way to do that?</p>