Hi,

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
oks

Hi oks

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.