PDA

View Full Version : macro excel report flickering



issacraj
07-14-2012, 11:07 PM
hi all,

i am extracting a ASCII file to get a excel report... i have done it.... what i did is i recorded the macro...and did all column row adjusting in it...when i open my report it opens fine but since macro as recorded all the code to design the report...it flickers while loading...i want the report to freeze and load without any flickering any though in that.... do help.......thanks in advance

issacraj
07-15-2012, 12:39 AM
hi all i used Application.ScreenUpdating = False Application.ScreenUpdating = true... in my code and stopped the flickering but the focus turns to 14 th or 15 th record after my report finishes loading how can i get the focus back to a1 or a3... do help

thanks in advance

mikerickson
07-15-2012, 12:52 PM
Application.Goto will direct the selection to where you want it.

issacraj
07-15-2012, 10:32 PM
thanks mikerickson for the reply...