vbfbryce - I'm not sure if the hesitation would impact the code after or not. I just added a delay code (10 sec.) after the below code and ran it just for the fun of it. It didn't work.

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & Range("B2").Value, _
Destination:=ActiveSheet.Range("b4"))