Hi,
Attached macro help me to search about one word in Google and get the result in column B but Google Blocked Me, so can you help me to update the macro to wait between each search for 1 min to avoid the Block.
Thanks;
Ehab
Hello,
I do recommend you to check out the blog section, there are great articles to be found there.
https://www.myonlinetraininghub.com/pausing-or-delaying-vba-using-wait-sleep-or-a-loop
Hi Anders,
Grateful for your support. I tried to use below in macro but I got issue to run it, so could you please help me to update the code in attached macro.
Application.Wait (Now + TimeValue("0:00:50")) 'Wait for 50 seconds
Thanks;
Ehab
Hello,
What kind of issue do you have when running the code? Is it what Philip writes in his article?
"The big drawback of using Wait or Sleep, is that Excel locks you out until the wait/sleep period has finished. You can use CTRL+BREAK to interrupt the macro, but Excel won’t accept input from the keyboard or mouse whilst paused using Wait or Sleep."
Now. It works perfectly. Thank you so much!
Thanks;
Ehab
