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
Hi User, Thank You for visiting My Blog. Please post your genuine Feedback or comments only related to this Blog Posts. Please do not post any Spam comments or Advertising kind of comments which will be Ignored.