i've heard that you can freeze screen while running macro to gain time

[writelearner]

but i don't know how to do

[RobDog888]

I think its only in Excel, but here is how you do it.

'To turn off updating to gain speed.
Application.ScreenUpdating = False
'To turn it back on.
Application.ScreenUpdating = True

[Br1an_g]

as RobDogg said, the screenUpdating is the way to go, but is Excel only.

i use this, but at the end of the loop i enable it to let the user see that the spreadsheet is actually doing something as if you have a long loop, the user sometimes thinks its crashed and will quit the app.

so at the beginning of the time consuming loop, disable, and at the end of the loop enable, thus giving an intermittent update of the screen.

HTH

[writelearner]

thanks

[Ecniv]

If you are using a userform, you can update a label caption with info like percentage complete, which you only need to update every three seconds. This lets the user see that the app is doing something. If you decide to do this, use DoEvents after updating the caption, or the window will not refresh.