VBA Tips & Tricks: Sleep Function in Excel VBA
Application.Wait as Sleep in VBA You can use Application.Wait instead of sleep function to hold the process for a specified period of time. Here is the way to achieve that: Sub Setting_Sleep_Without_Sleep_Function() Debug.Print Now Application.Wait DateAd...