View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gunnar Johansson Gunnar Johansson is offline
external usenet poster
 
Posts: 47
Default Application.ScreenUpdating = False and it still flicker !

Sorry, I think my application is to large for the usergroup. The code
sometime call other subs etc. It is hard to separate the code.

Maybe I found one reason however - to ensure the formats in the sheets, I
run cells.copy at a "rerference sheet" and "cells.pastespecial " to paste
formats in to the activesheet. This might cause some small differentces in
column with and row height. Maybe I should paste values into the reference
sheet "up to date". Maybe that I see is a format paste to the activesheet
from the "reference sheet" and then a fast reformation to the cells with
values.

I report later the outcome of this,

Thank you all


"Tom Ogilvy" skrev i meddelandet
...
Post your code and others can see if they can reproduce it or recognize

what
might be problematic.

--
Regards,
Tom Ogilvy

"Gunnar Johansson" wrote in message
...
Hi,

I try once again since I didn't get a usable respons last time.

I have "Application.ScreenUpdating = False" in first row after "Sub.."

and
has
it as "= True" the last line just before "End Sub"

I belive many of you find this flickering but for some, often smaller
macros, there is NO flickering. The question is - WHYdoes it occure when
screenupdating=false? Is it just some special commands, is it the length

of
the code, is it the screenupdating=false command itself??? ... or?

If some of you know if there is some special commands that create screen
flicker despite screenupdating=false, please tell so I can try to avoid

it
and use other
solutions instead.

/Regards