Can I only recalculate a part of a worksheet?

C

Chris

Dear all,

My .xls file consists of several worksheets. Manual recalculation of
these worksheets is slow. May I know if it is possible to make a button
which only recalculates a part of a worksheet, say A1:B100 of Sheet 1?
Thanks.

Best Regards,
Chris
 
D

Debra Dalgleish

You could make a button that calculated the selected cells. For example:

Sub MyCalc()
Selection.Calculate
End Sub
 
Top