different behavior stepping through v run

  • Thread starter Thread starter Mike Williams
  • Start date Start date
M

Mike Williams

With Windows XP (SP-1) and Office/Excel SP (SP-2):
I'm a bit puzzled. At the end of a procedure I have another small routine
that loops through all worksheets in a workbook and resets the screen,
essentially, by repositioning to the top left and selecting cell D4. When I
run the procedure, it doesn't work. When I step through it, it works fine.
I'd be grateful for any suggestions, or insight into why this difference.
THANKS.
 
Hi
as always :-)
please post the relevant code - otherwise the best we can offer are
guesses :-)
 
I messed around with it some more, and the problem went away. I think it
had to do with a line above the code in quesiton:
"Application.ScreenUpdating = False". I believe killing that line fixed
the problem.
 
Another way could be to add the line
Application.ScreenUpdating = True
at the end of your code
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Which textbox am I in? 1
Stepping through v. running code 1
Stepping through Code 7
Unwanted Calculation 5
Step-through works, Run does not? 6
Application.quit error 3
Weird ignoring of one item in a loop 5
Resizing of picture different in run time and design time 3

Back
Top