Refreshing

[SQUIDD]

Hello

I have a macro that cycles a whole load of pages and imports data.Is there a way i can have it show just 1 page while it is doing its thing.The page showing will have data on it that changes so i would want it to show the updated data.

This may be a simple way for me to have a progress moniter.
Any advice.

Dave

 

[Andrew Poulsom]

This:

Application.ScreenUpdating = False

will suppress screen refreshes. You can set it to True when you want, but if you have activated another sheet, that's the one that will appear on the screen.

 

[SQUIDD]

thankyou for your help.

I was hoping that 1 page would be able to stay on display refreshing.
Never mind.

Dave

 

[Andrew Poulsom]

If you avoid activating the other sheets the initial sheet will always be displayed. It's rarely necessary to activate/select objects in VBA in order to work with them.

 

[SQUIDD]

ADVERTISEMENT

Hi andrew

Thanks for your help, so you are saying if i stop screen updating and start the macro running from that page that screen will always display and when data changes on that sheet it will also change.

I will give it a go.

Dave

 

[ossuary]

You can also read and write information from and to other sheets without actually selecting or activating them, most of the time (with most types of data manipulation). Just avoid doing things like

Sheets("Sheet2").Select or .Activate, and don't rely on things like Selection.Copy - just tell Excel which areas to copy or paste or manipulate without actually selecting them.

 

[SQUIDD]

Thankyou for your help.
I have made something that works well.
I have to make screenupdating true just for 1 bit then make it false again.
works excellent.

Dave