excel - Visual bug when displayheadings = false -


as title says, experience visual bugs when , when

activewindow.displayheadings = false 

here image of type of bug receive (the masterfully blued-out info due confidential work information, don't mind it). happens when scroll left-right:

heading on, bug

after refreshing (no bug):

after refreshing, no bug

note there black stripe , cell on right, merged cell looks sort of cut in half? looks others normally.

selecting makes bug disappear in selected region. such, have developped little macro refresh screen. selects whole screen - erasing bugs - , returns selected range. works fine.

application.screenupdating = false dim active range set active = activecell  cells.select active.select application.screenupdating = true 

now, 1 of 2 things, preferrably first:

1) figure out why happens, if happens me, , how fix it.

2) think of way launch refresh macro every time user scrolls side side.

additional info:

excel 2010

happens whether application.enableevents, screenupdating, etc true or not.


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -

jdbc - Not able to establish database connection in eclipse -