I'm doing a web scrape in VBA (see code below) to btc-e.com to fetch prices of some Cryptocurrency. When to it manually by going to data tab and then clicking on from web It works fine, but When I do it in the Macro I only get back "please wait..." The page displays "please wait..." as it loads and the macro assumes that is the entire page. I have been looking for a way to make the macro wait for the full page load and cant find anything.I'm doing a web scrape in VBA (see code below)