I'm not sure what ou want to accomplish, but the Calculate method can be used to perform the calculation when you need it. Calculate can be applied at the Workbook, the Worksheet or a specified Cell Range level e.g.
Application.Calculate
Worksheets("Sheet2").Calculate
ActiveShet.Range($A$1:$B$10).Calculate
Bookmarks