Search Office
Sign in
Home Products Office 365 Docs Samples Downloads Training How To Support Forums
Office and SharePoint development > Office client development > Office 2010 > Excel 2010 > Excel 2010 Developer Reference > Reference > Application Object > Methods > Application.Calculate Method (Excel)
Office and SharePoint development
Office client development
Office 2010
Excel 2010
Excel 2010 Developer Reference
Reference
Application Object
Methods
Application.ActivateMicrosoftApp Method (Excel)
Application.AddCustomList Method (Excel)
Application.Calculate Method (Excel)
Application.CalculateFull Method (Excel)
Application.CalculateFullRebuild Method (Excel)
Application.CalculateUntilAsyncQueriesDone Method (Excel)
Application.CentimetersToPoints Method (Excel)
Application.CheckAbort Method (Excel)
Application.CheckSpelling Method (Excel)
Application.ConvertFormula Method (Excel)
Application.DDEExecute Method (Excel)
Application.DDEInitiate Method (Excel)
Application.DDEPoke Method (Excel)
Application.DDERequest Method (Excel)
Application.DDETerminate Method (Excel)
Application.DeleteCustomList Method (Excel)
Application.DisplayXMLSourcePane Method (Excel)
Application.DoubleClick Method (Excel)
Application.Evaluate Method (Excel)
Application.ExecuteExcel4Macro Method (Excel)
Application.FindFile Method (Excel)
Application.GetCustomListContents Method (Excel)
Application.GetCustomListNum Method (Excel)
Application.GetOpenFilename Method (Excel)
Application.GetPhonetic Method (Excel)
Application.GetSaveAsFilename Method (Excel)
Application.Goto Method (Excel)
Application.Help Method (Excel)
Application.InchesToPoints Method (Excel)
Application.InputBox Method (Excel)
Application.Intersect Method (Excel)
Application.MacroOptions Method (Excel)
Application.MailLogoff Method (Excel)
Application.MailLogon Method (Excel)
Application.NextLetter Method (Excel)
Application.OnKey Method (Excel)
Application.OnRepeat Method (Excel)
Application.OnTime Method (Excel)
Application.OnUndo Method (Excel)
Application.Quit Method (Excel)
Application.RecordMacro Method (Excel)
Application.RegisterXLL Method (Excel)
Application.Repeat Method (Excel)
Application.Run Method (Excel)
Application.SaveWorkspace Method (Excel)
Application.SendKeys Method (Excel)
Application.SharePointVersion Method (Excel)
Application.Undo Method (Excel)
Application.Union Method (Excel)
Application.Volatile Method (Excel)
Application.Wait Method (Excel)
Expand Minimize
3 out of 4 rated this helpful - Rate this topic

Application.Calculate Method (Excel)

Office 2010

Calculates all open workbooks, a specific worksheet in a workbook, or a specified range of cells on a worksheet, as shown in the following table.

expression .Calculate

expression A variable that represents an Application object.

To calculate

Follow this example

All open workbooks

Application.Calculate (or just Calculate)

A specific worksheet

Worksheets(1).Calculate

A specified range

Worksheets(1).Rows(2).Calculate

This example calculates the formulas in columns A, B, and C in the used range on Sheet1.

VBA
Copy 
Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.