Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Suspending Updates

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to suspend cell updates from VBA temporarily?

    I am finishing up some VBA code that creates a report, it runs fine. But when I include formulas and analysis in the spreadsheet for this report, the VBA program runs VERY SLOW. The automatic cell updates between each data change are just too much.

    I want to turn cell updates off at the beggning, and turn them back on at the end. How can I do that?

    Thanks much,

    John

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-04 18:36, John McGraw wrote:
    Is there a way to suspend cell updates from VBA temporarily?

    I am finishing up some VBA code that creates a report, it runs fine. But when I include formulas and analysis in the spreadsheet for this report, the VBA program runs VERY SLOW. The automatic cell updates between each data change are just too much.

    I want to turn cell updates off at the beggning, and turn them back on at the end. How can I do that?

    Thanks much,

    John
    You could try this:

    Code:
    Calculate
    With Application
        .Calculation = xlManual
    End With
    'the rest of your code
    With Application
        .Calculation = xlAutomatic
    End With
    Regards,

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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