annoying flcker as macro copies from one sheet to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

none - 05 Oct 2007 08:34 GMT

I have a macro in excel 2003 that

1. Reads the contents of a cell on one sheet
2. processes the value
3. Writes the new value to a cell on another sheet

It does the three steps hundreds of times for different cells in a grid.

When the macro runs it jumps from sheet to sheet to sheet again in an
annoying way. Is it possible to have the macro run but not update the
screen as it goes? In some way get the macro to save the updates in
memory and write them to the screen in one go when the macro terminates?

thanks

Reply to this Message

papou - 05 Oct 2007 08:55 GMT

Hello
Yes you can use:
Application.Screenupdating = False
And remember to set it back to True when you're done.
But you may also consider informing users that some processing is running
with for instance:
Application.StatusBar = "Currently processing values...please wait"

In which case you 'll have to write the code as follows:
Application.StatusBar = "Please wait currently processing values..."
Application.ScreenUpdating = False
'do your stuff
Application.ScreenUpdating = True
Application.StatusBar = False

HTH
Cordially
Pascal

>I have a macro in excel 2003 that
>
[quoted text clipped - 10 lines]
>
> thanks

Reply to this Message

|Walter Rincon| - 05 Oct 2007 09:07 GMT

this will do the trick

before doing whatever your macro does put this line

application.screenupdating=false

then AFTER your macro has finished doing it's job, put this line

application.screenupdating=true [ because you want your users to keep that
feature un-touched]

regards.

|I have a macro in excel 2003 that
|
[quoted text clipped - 10 lines]
|
| thanks

Reply to this Message

Rate this thread: