VBA help

Does anyone on here know VBA? I need help understanding why a Macro I wrote in excel isn't working right. This program is supposed to take what is in Cells(2, 7), run a google search, collect the resultstats, and record those stats in Cells(2, 4). Then shift down one line and run again until the cell is empty. The problem is I run into error 80070005, which from what I've read is because google doesn't let you do a lot of searches at a time. To get around this, I'm trying to program the code to on error change the XMLHTTP object and continue on the list. However, I keep running into an overflow error on the ErrCount = ErrCount + 1. I'm not sure why or how to avoid it. I'm only just now learning VBA, so I could really use some help. Any thoughts?

here's the code:

 

That was because MSXML2.XMLHTTP is already called in the regular code. I thought of a different way of doing this that avoided using the error handle by creating a RunCounter that counted after every run through the loop, and set if Then statements on each HTML object to trigger on multiples of 1 + 5x, but I'm still trying to figure how to code that properly. Back to reading :/

 

I'm asking for help there too, but I was hoping some INFJs might know some computer lingo and be willing to help out


EDIT:
Here's the link to stackexchange where I asked for help. The information there is more detailed.
In case anyone wants to help....No one there has said anything on my post yet :/

http://stackoverflow.com/questions/...oogle-collect-resultstats-error-code-80070005

 

If anyone is interested in helping out, here's my newest attempt at the code. I added the If/End If statements and the XMLRun ="X" to try to track what object is being used.

If anyone has some tips, I could really use some. If no one wants/has time to help with this, then I'll stop posting here after this comment.
Thanks