Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to have control of the calculation to specific ranges
Hi,
I take this from another thread since it developed to another direction. I have a lot of links and after a cell value is changed, it take far to many seconds afterwards for the calculation to be possible to use it. Is it possible to: A/ Inhibit the common Application.Calculate that run after every change? B/ Just calculate specific ranges in specific sheets after a worksheet_change? C/ Be sure to cover every aspect to swicht it on again when leaving the workbook, and then continue with "the inhibited way" when returning to the workbook? Please answer any of these, or all if possible. /Kind regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation for varying ranges | Excel Worksheet Functions | |||
How to control calculation of specific cells | Excel Worksheet Functions | |||
Better control of axis ranges | Charts and Charting in Excel | |||
How do I return a calculation based on several ranges? | Excel Worksheet Functions | |||
Control of named ranges | Excel Programming |