This VBA MACRO can help you to refresh selected cells. If you are working on a large and complex data then macros come handy.I found this one from a forum for my friend he used to work for a company where they have to crunch large workbooks. He had to refresh a particular cell or a group of cells again and again.
Here is the code. You have to place error handling near the ‘Set rng’ line.
Public Sub RecalculateSelection() Dim rng As Range Set rng = Application.Selection rng.Calculate End Sub
Here is another VBA function that can update or refresh cells automatically whenever there is a change in workbook.
Private Sub Worksheet_Change(ByVal Target As Range) If GetXLCol(Target.Column) = "G" Then Calculate End If End Sub Your ads will be inserted here byEasy Plugin for AdSense.Please go to the plugin admin page toPaste your ad code OR Suppress this ad slot.
Now if you want to recalculate whole spreadsheet use this command :
The another command
will recalc only the specific workbook, to recalculate a specific range i would suggest you to try
One can also download this RangeCalc command button that will perform the same function,it works in excel 2007,2010