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 Feedback/Comments/Query.

Subscribe to Blog Posts by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts