Two ways I have used after being told about them from kind people on the
newsgroup



For whole seconds delay use "wait"



Application.Wait Now() + TimeValue("00:00:03")



'Put it before the Next Command







If you need half a second then put the following at the top of the module



Declare Sub Sleep Lib "kernel32" (ByVal dwMilliseconds As Long)



And then the following in your code where you want the pause



Sleep 500