Excel Web Query VBA - Can I loop through rows and columns?

[daniyielle]

Hi all. I have been trying to scour the internet for what I am trying to do and have had little to no success. So this is my last resort.

I am trying to run a Dynamic Web Query VBA in Excel and need a little help. I currently have a query that takes values in cells A2, B2, C2 and D3 and pulls the data to F1 on the same spreadsheet.

What I am having problems with is trying to loop the query so it takes values in cells A4, B4, C5 and D4, enters the data into F4 and continues until it has reached two consecutive empty cells in column A.

The code I have so far is in the VBA with the attached sample spreadsheet that shows what I am working with.

Once I have all of the queries performed, I then have a macro that I will call that will delete all of the blank rows so I only have one header from the query.

[AB33]

Try the attached.

[daniyielle]

I had to change A4 to A2, but it works like a charm. Thank you soooo much!