Sleeping a sub (not the entire program!)

[Phobic]

Simple. Don't use sleep. Either tell the code to stop executing and restart under certain circumstances, or:

While X <> 10
DoEvents
Loop
'Nothing happens till X = 10