| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can I only recalculate a part of a worksheet?
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| email part of worksheet | Excel Discussion (Misc queries) | |||
| Excel to recalculate a worksheet based on a time interval | Excel Worksheet Functions | |||
| copy part of a worksheet into a worksheet in the same file/keepi. | Excel Worksheet Functions | |||
| Locking Part of a Worksheet/Tab | Excel Discussion (Misc queries) | |||
| protect only part of a worksheet | Excel Programming | |||
Linear Mode
