Can I only recalculate a part of a worksheet?

  • Thread starter Thread starter Chris
  • Start date Start date
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
 
You could make a button that calculated the selected cells. For example:

Sub MyCalc()
Selection.Calculate
End Sub
 
Back
Top