Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie

VBA application.calculate not working for all cells

Options
  • 24-02-2014 1:06pm
    #1
    breadmonkey
    Registered Users Posts: 3,608 ✭✭✭


    Hi,

    I have a block of code that essentially goes like
    sub dostuff()

    ...some code

    application.calculateFullRebuild

End Sub

    There is one cell containing the following formula that does not recalculate when the macro is finished and instead shows a #value error:

    =FIND("TR", CELL("filename")

    If I then manually refresh again after the macro is complete, the cell reculates no problem. Saving the workbook before the recalculate doesn't solve the problem.

    Any ideas?


Comments

  • Options
    #2
    Stainless_Steel
    Closed Accounts Posts: 1,155 ✭✭✭Stainless_Steel


    Did you turn off automatic calculations? As in:

    Application.Calculation = xlManual

    If so, you should turn it back to auto at the end of your method.

    PS: I think your code is wrong. From memory it should be Application.Calculate


Advertisement