PDA

View Full Version : What is Application.Calculate



avadhutd2
09-10-2009, 02:29 AM
Hi,

I am working on a excel code to add few things. In the code I can see Application.Calculate line at one stage.

What do the application.calculate exactly do & where it is used?
Are there any specific situations where we use application.calculate?I referred the HELP file, but I am getting confused as why it is needed?

Please let me know...Thanks!

Bob Phillips
09-10-2009, 02:49 AM
Help says

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.

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

Doesn't that say it all?