+ Reply to Thread
Results 1 to 4 of 4

Generate Report Tables Faster, with Smarter Code.

  1. #1
    Registered User
    Join Date
    03-10-2010
    Location
    kampala, uganda
    MS-Off Ver
    Excel 2007
    Posts
    15

    Generate Report Tables Faster, with Smarter Code.

    Hi all. I'd like to improve the performance of the macro submitted below. it is written to generate a a report, which could have as many tables as might be needed. The macro is accumulated from contributions on this forum (credits to excel forum). The macro has three functions, two that handle the formating of the report cells, and a third to regenerate as many tables as the user might require.
    Can any changes be made to this macro to improve its performance? Notice that while the macro is running the screen keeps updating, which slows down the macro. I think also, because i'm a newbie to macros, that the code could do with numerous improvements. Any changes made to the code are welcome.
    BryenWalt
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Generate Report Tables Faster, with Smarter Code.

    not a charting topic. Moved to Programming Forum.

    Bryen, please select an appropriate forum before starting a new thread.

  3. #3
    Registered User
    Join Date
    03-10-2010
    Location
    kampala, uganda
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Generate Report Tables Faster, with Smarter Code.

    Oh, Teylyn, i had not noticed this error. Is there anything i can do to sort it, or does your moving it to the Programming Forum cover it? thx

  4. #4
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Generate Report Tables Faster, with Smarter Code.

    Since you turn off/on screen updating in the main procedure I think you can remove all references to it from the other procedures.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1