Sunday, 21 June 2015

How to Calculate a Specific Range in Excel with VBA

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

'To Calculate ActiveSheet

End Sub

Output :

No comments:

Post a Comment

Hi User, Thank You for visiting My Blog. Please post your open Feedback only related to this Blog Posts. Please note that I cannot respond to the Anonymous Comments.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts