Help with EXCEL - Pausing a macro

[EpsiIon]

I've been looking for 30 minutes and I can't find a simple answer anywhere. I've got a macro that changes the value of some cells and then prints them out. Instead of printing these cells, I want to simply scan the cells as they change (to make sure there are no errors). I simply can't find a way to get the macro to pause for about 1/2 a second so that I can process what I'm seeing. Can anybody here help me?

Keep in mind that I know next to nothing about VB, and the macro looks as if it was created IN EXCEL (rather than the VB editor bundled with Excel). I tried =PAUSE( # ) and =WAIT( # ), but neither of those seems to work. Any advice or help is greatly appreciated.

Thanks!
Epsilon

 

[NeoV]

Try this :

Sub Wait5Sec()
Application.OnTime Now + TimeValue("00:00:05"), "other sub routine"
End Sub

 

[tkdkid]

Create a breakpoint and step through the code.