[已解决]关于重算当前活动的代码

快乐童年

  大家好，我知道如果勾选手动重算后。每次手动重算当前活动表时。要么得点菜单儿，要么用快捷键shift+f9,我感觉都很麻烦，可不可以，写一段代码，再设个按钮 操做起来就方便啦。希望高手能成全一下

最佳答案

月排行榜 / 总排行榜

mxg825

2012-8-6 17:17

ActiveSheet.Calculate '重算当前工作表

跳转到最佳答案楼层

suye1010

office 2007以上版本中已经有这个按钮了

mxg825

ActiveSheet.Calculate '重算当前工作表

suye1010

Excel里面的帮助，你要是自己想写，就照着抄吧

Worksheet.Calculate Method
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.
Syntax

expression.Calculate

expression   A variable that represents a Worksheet object.

Remarks


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


Example


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

Visual Basic for Applications
Worksheets("Sheet1").UsedRange.Columns("A:C").Calculate