var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Irritating screen refresh when copying values from one workbook to another
I have a macro which copys values from one workbook to another therefore flipping from workbook to workbook. When copying, the screen keep refreshing and is a real irritation for the eyes.
So I would like to know if there is any good solution to overcome this problem.
Thanks & Regards
All you need is at the start of the process put in the line
applicaiotn.screenupdating = false
at the end
Application.ScreenUpdating = True
as you can probably tell this stops the screen updating, with the added bonus of helping your code run faster
Thanks so much.
Finally, I don't have to strain my eyes.