Recalculating multiple cells

[shodie]

Hi

How do you reclaculate multiple cells within a worksheet? I want to be able to highlight certain cells and then refresh them.

Using F2 in each cell takes to long.

I don't want to refresh the entire worksheet so can't use F9
The cells are not in an array or range.

Thanks.

 

[AlphaFrog]

You could assign this macro to a short-cut

[color=darkblue]Sub[/color] Recalc_Selection()
    [color=darkblue]On[/color] [color=darkblue]Error[/color] [color=darkblue]Resume[/color] [color=darkblue]Next[/color]
    Selection.Calculate
[color=darkblue]End[/color] [color=darkblue]Sub[/color]

 

[Teeroy]

Also, if the cells are always the same, you could combine them as a named range and modify Aphafrog's macro to use that rather than selecting them each time.

 

[shodie]

I haven't worked much with macros. Would I have to set this macro up for every spreadsheet?

The cells requiring recalcuation will change.

 

[AlphaFrog]

It will recalculate your currently selected cells.