Reclaculating a selected range
 

Is there a way I can recalculate only a small part of the whole sheet
(the selected range)? This will help me reduce calcuation time on a
very large and complicated worksheet.

Thanks
Utkarsh

Reclaculating a selected range
 

Depending on the version of excel (IIRC), there's some vba code that will
recalculate a range:

Range("a1:x99").calculate

But IIRC (and I may not), Charles Williams says that this is kind of dangerous.

You may want to search his site for calculation tips:
http://www.decisionmodels.com

In fact, you may want to browse his site to see if you can improve your design.


wrote:

Is there a way I can recalculate only a small part of the whole sheet
(the selected range)? This will help me reduce calcuation time on a
very large and complicated worksheet.

Thanks
Utkarsh

--

Dave Peterson

Reclaculating a selected range
 

Thanks a ton, Dave

If you want to go down the macro route, you might want to try something like:

Sub RecalcSel()
For Each xCell in Selection.Cells
oFormula EQUALS xCell.FormulaR1C1
xCell.value EQUALS xCell.value 'Fixes cell value and triggers cells dependent on this one to recalc too
xCell.FormulaR1C1 EQUALS oFormula 'Replaces formula and recalcs it
Next xCell
End Sub

MB