Wednesday 15 April 2015

excel - Vba Screen flickering after using Screenupdating = False -



excel - Vba Screen flickering after using Screenupdating = False -

i have vba code includes application.screenupdating = false. have checked debug.print , @ each stage of within code, screenupdating = false. however, screen still keeps flickering. have read several google posts on nil has been helpful.

please see next code:

application.screenupdating = false sheet3.benchmark1.clear sheet3.benchmark2.clear sheet3.offshorefund_list.clear application.screenupdating = true

thanks, adam

excel vba excel-vba flicker

No comments:

Post a Comment