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 :

Calculate

The another command

Worksheets(“sheet1”).Calculate

will recalc only the specific workbook, to recalculate a specific range i would suggest you to try

Range(“A1:C5”).Calculate

One can also download this RangeCalc command button that will perform the same function,it works in excel 2007,2010