Hi all,

Is there a command within Excel VBA that will cause a macro to pause for a set amount of time? I have found the following which pauses it but the minimum pause time is 1 second, and this is too long:

Code:
Application.Wait Now + TimeValue("00:00:01")
What I need is something that pauses for, say, 0.1 seconds. Is there anyway to do this?

Cheers
-Rob