Macro causes Run time error 1004 Application defined or object-defined error

I created a macro to do 47 web queries. It's grabbing data from our forum profiles of our members. When I first created the macro it ran flawless. The next day I jump on my computer and try to run the macro I get the run time error.

The code stops at the first line highlighted in red. If I make a single macro for each query it works. When I make the macro to do 47 queries it works a couple times then I get the run time error. I searched the forums here for an answer and tried theOffice Help. I'm am new to this so any help would be appreciated. Is there anyway to fix this?

Please Login or Register  to view this content.

I figured it out. I wasn't allowing enough time for the macro to gather the data.