Even I am also curious to know the solution

The issue is the Turning off the Screen updating won't worked for the Worsheet Change Events and from my experience which makes the flickering even more.

Any solution for this issue?

http://www.excelforum.com/excel-prog...t-working.html