Excel Macro to Calculate a Specific Range
Suppose we have a data as follows, where we have the Formulas in column C.
Now , we can refresh only the Range("A2:C5") as follows :
Sub Refresh_Range()
'To stop the workbook Calculation Manual
Application.Calculation = xlCalculationManual
'To Calculate Specified Range in a ActiveSheet
ActiveSheet.Range("A1:C5").Calculate
'To Calculate ActiveSheet
'ActiveSheet.Calculate
End Sub
Suppose we have a data as follows, where we have the Formulas in column C.
Now , we can refresh only the Range("A2:C5") as follows :
Sub Refresh_Range()
'To stop the workbook Calculation Manual
Application.Calculation = xlCalculationManual
'To Calculate Specified Range in a ActiveSheet
ActiveSheet.Range("A1:C5").Calculate
'To Calculate ActiveSheet
'ActiveSheet.Calculate
End Sub
Output :
No comments:
Post a Comment