+ Reply to Thread
Results 1 to 3 of 3

Stop all calculation

Hybrid View

  1. 01-18-2014, 03:47 AM #1
    phil2006
    phil2006 is offline
    Forum Contributor
    Join Date
    06-05-2006
    Posts
    166

    Stop all calculation

    Hi,

    I need to stop calculations temporarily if possible. Ideally I will be able to do this in VBA. Bascially, I have a Macro running that involves pasting but still needs to read from the original values in other areas of the workbook after I have pasted. Even when I have changed the calculation to manual the formulae in all cells updates when the macro pastes. Ideally I need this not to happen and for cells to only calculate when instructed to do so in the macro. Is this possible?

    Many thanks in advance,
    Phil
    Reply With QuoteRegister To Reply
  2. 01-18-2014, 03:52 AM #2
    Sean Thomas
    Sean Thomas is offline
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: Stop all calculation

    this usually works

    change to manual before copying
    Application.Calculation = xlCalculationManual
    change back to auto when finished
    Application.Calculation =xlCalculationAutomatic
    Regards
    Sean

    Please add to my reputation if you think i helped     (click on the star below the post)
    Mark threads as "Solved" if you have your answer     (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:     [code] Your code here [code]
    Please supply a workbook containing example Data:     It makes its easier to answer your problem & saves time!
    Reply With QuoteRegister To Reply
  3. 01-18-2014, 04:57 AM #3
    HaHoBe
    HaHoBe is offline
    Forum Guru HaHoBe's Avatar
    Join Date
    02-19-2005
    Location
    Hamburg, Germany
    MS-Off Ver
    work: 2016 on Win10 (notebook), private: 2019 on Win10 (desktop), 2019 on Win11 (notebook)
    Posts
    8,198

    Re: Stop all calculation

    Hi, phil2006,

    Even when I have changed the calculation to manual the formulae in all cells updates when the macro pastes.
    Any events involved on pasting behind the worksheet?

    Ciao,
    Holger
    Use Code-Tags for showing your code: [code] Your Code here [/code]
    Please mark your question Solved if there has been offered a solution that works fine for you
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. STOP calculation after a condition has been met?
    By ryefield in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-01-2013, 07:24 PM
  2. How do I stop calculation??
    By jimojimo in forum Excel General
    Replies: 5
    Last Post: 04-16-2010, 12:03 AM
  3. How do I stop a calculation rounding up
    By Lynneth in forum Excel General
    Replies: 8
    Last Post: 01-13-2006, 04:00 PM
  4. How to stop automatic calculation
    By Arthur in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-06-2005, 10:06 AM
  5. Keystroke to stop Calculation?
    By Flamikey in forum Excel General
    Replies: 0
    Last Post: 04-11-2005, 08:44 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1