Getting Excel to refresh data on sheet from within VBA

Getting Excel to refresh data on sheet from within VBA

Asked on January 10, 2019 in Excel.
Add Comment


  • 3 Answer(s)

    The following solution will explain about getting Excel to refresh data on sheet from within VBA

    ActiveSheet.EnableCalculation = False
    ActiveSheet.EnableCalculation = True
    
        In all functions, the .Calculate() method will not functioning, and it on a sheet along with add-in array functions.

    Answered on January 10, 2019.
    Add Comment

    Try this best solution :

    *//recalculate all open workbooks
    Application.Calculate
     
    *//recalculate a specific worksheet
    Worksheets(1).Calculate
     
    *//recalculate a specific range
    Worksheets(1).Columns(1).Calculate
    
    Answered on January 10, 2019.
    Add Comment

    You can use either this solution

    Application.CalculateFull
    

    Or this solution

    Application.CalculateFullRebuild
    
       Rebuilding all open workbooks, relatively than the active worksheet. CalculateFullRebuild rebuilds assurance.

    Answered on January 10, 2019.
    Add Comment


  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of service.