View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E AA2e72E is offline
external usenet poster
 
Posts: 400
Default Can I only recalculate a part of a worksheet?

Try:

Range("A1:B100").Calculate

"Chris" wrote:

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