Reclaculating a selected range

U

utkarsh.majmudar

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
 
D

Dave Peterson

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.
 
B

BizMark

Thanks a ton, Dave
Click to expand...

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

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

M
 
Top