Calculate Specific (Contiguous) Cells Only

[velohead]

I'm working on a huge spreadsheet, that I inherited from a previous incumbant.

I would like to re-calculate (ie F9) just 12 specific contiguous cells which are monthly totals, from a manual data input area.

Calculating 'just' the worksheet on which they reside would take too long, let alone the entire workbook !
Hence, just want to recalc those 12 cells.

Is there any VB code whereby......
a) I select the contiguous area by hand (i can write that bit)
b) press icon button, and the highlighted selection recalculates.

As implied, a VB solution is ideal.
Thx.

 

[Datsmart]

This page will tell you your options:
http://support.microsoft.com/default.aspx?scid=kb;en-us;214395

Basically,
Shift=F9 to calculate the active worksheet.

F9 for the entire workbook.

 

[Sandeep Warrier]

Hi

After setting your calculation mode to manual, use the following code (you can assign it to a button too)

Sub CalculateSpecificCells()
Sheets("XYZ").Range("A1:A10,B25,C30,D15:20").Calculate
End Sub

Change the sheet name and ranges to suit your data.

Contiguous ranges can be written as, for example, A1:A10.... you can specify non-contiguous ranges by separating it with a comma. Note that all should be included within the "".

Hope this helps.

 

[velohead]

Thanks Sandeep, that looks like exactly what I need.

I'll try this out once I can get my head above the water (very busy at work, too busy infact).

Thanks Again