Results 1 to 4 of 4

Thread: macro excel report flickering

  1. #1

    macro excel report flickering

    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 flickers while loading...i want the report to freeze and load without any flickering any though in that.... do help.......thanks in advance

  2. #2
    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

  3. #3
    Mac Moderator VBAX Guru mikerickson's Avatar
    May 2007
    Davis CA
    Application.Goto will direct the selection to where you want it.

  4. #4
    thanks mikerickson for the reply...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts