Thanks,
I may be able to use this option.
--
Gary Baker


"Earl Kiosterud" wrote:

I think you'll have to forget the slow-motion. To set a breakpoint, put the
cursor on the line where you want it to break (pause execution). Press F9.
It will turn it red. Now when you run the macro, it will stop on that line,
highlighting it in yellow and bold text, not having executed it yet. From
that point, you can press F5 to continue at VBA's breakneck speed (which you
can almost watch anyway!), or F8 to step it. YOu can Alt-Tab back to Excel
at any time to see the effects on the sheets. Wherever it stops with a line
highlighted in yellow is a line that has not yet been executed. You can put
breakpoints in several places.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"GWB Direct" wrote in message
...
Can I put a breakpoint in the code and watch it in excel after I hit the
button for the macro. I want to see visually what is happening but at a
slower pace. How do I put a breakpoint line in my macro and where do I put
it. Does it go before the With section or after the End With section.
--
Gary Baker


"Earl Kiosterud" wrote:

Gary,

You can step it with F8 (in the VBE), and Alt-Tab back to Excel and watch
stuff happen. Or put Excel and the VBE in windows (unmaximized). Or you
can put a breakpoint (F9) on a line to stop it at selected places.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"GWB Direct" wrote in message
...
Is there a line of code that I can add to my macros that would pause
between
each with or end with statment. I would like to view it slower than it
works
right now.
--
Gary Baker