macro excel report flickering

[issacraj]

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]

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]

Application.Goto will direct the selection to where you want it.

[issacraj]

thanks mikerickson for the reply...