Wait until Application.Calculate has finished

by

Further to my comments, you can use DoEvents with the Application.CalculationState. See this example

Application.Calculate
If Not Application.CalculationState = xlDone Then
    DoEvents
End If
'~~> Rest of the code.

If you want you can also use a Do While Loop to check for Application.CalculationState

I would also recommend see this link

Topic: Application.CalculationState Property

Link: http://msdn.microsoft.com/en-us/library/bb220901%28v=office.12%29.aspx

Quote From the Above Link

Returns an XlCalculationState constant that indicates the calculation state of the application, for any calculations that are being performed in Microsoft Excel. Read-only.

More Related Contents:

  1. VBA – Update Other Cells via User-Defined Function
  2. How to add events to Controls created at runtime in Excel with VBA
  3. How can an Excel Add-In respond to events in any worksheet?
  4. Handling Events for OLEObject CommandButtons created at Runtime
  5. Print function selecting wrong Type of Change option excel vba
  6. Format Cell Contents
  7. Excel formula checklist in employees
  8. How do I put double quotes in a string in vba?
  9. What is the difference between .text, .value, and .value2?
  10. How can I URL encode a string in Excel VBA?
  11. How do I slice an array in Excel VBA?
  12. VBA rounding problem
  13. Download attachment from Outlook and Open in Excel
  14. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  15. Embed picture in outlook mail body excel vba
  16. Use autofilter on more than 2 criteria
  17. 2 ways for “ClearContents” on VBA Excel, but 1 work fine. Why? [duplicate]
  18. Excel 2013 VBA Clear All Filters macro
  19. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  20. VBa conditional delete loop not working
  21. Load csv file into a VBA array rather than Excel Sheet
  22. Excel VBA: Range to String Array in 1 step
  23. Update excel sheet based on outlook mail [closed]
  24. Use Excel VBA to click on a button in Internet Explorer, when the button has no “name” associated
  25. Export chart as image – with click of a button
  26. Error13 in Excel VBA in data file
  27. How to extract text within a string of text
  28. How to capture process output asynchronously in powershell?
  29. VBA inheritance, analog of super
  30. How to protect Excel workbook using VBA?

Leave a Comment