Is there a VBA to refresh the screen?

[tonywatsonhelp]

Hi Everyone,

Is there a comand in excel vba that will refresh the screen?

the reson I ask is i get a lot of page bleeding and screen freezing and when i select another tab then select the same tab again it goes away,
so i was wondering if there was some kind of comand that just refeshed the screen ?

I use Application.ScreenUpdating = True of course but this needs to be triggered so i was woundering if there was a refresh i could use?

any ideas would be helpfull
thanks
Tony

 

[johnnyL]

When do you get the screen freeze?

 

[tonywatsonhelp]

Well its really hard to say exactly, as its very unexpected, its more screen bleeding than freezing, I select a tab and get A small amount of another screen showing on the page,
if i click back and forward it goes away but its very annoying

 

[johnnyL]

How frequently does this occur? Can you post your code/workbook?

 

[tonywatsonhelp]

No, the workbooks are all "work" books LOL so cant really do it I'm surprised others don't experience the same thing as i get it often enough to be a pain, but never mind.
thanks
for trying to help anyway.

 

[johnnyL]

From my google search, some possible causes:
1) memory issue
2) grouped sheets
3) using .Activate / .Select in code

 

[tonywatsonhelp]

So I use Sheet("Whatever name").select to navigate from one tab to another?
how else can i do this?
any ideas?
Thanks
Tony

 

[johnnyL]

You can google it to find much info. One example is here.