Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping one sheet from calculating
Hi folks.
Is there a way to turn the calculation of a particular sheet off and on using VBA while the VBA is working with data from another sheet? Thanks xt |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping one sheet from calculating
Hi,
Put this first "Application.Calculation = xlCalculationManual" then "Calculate" after running your macro. Hope it will help! ~jaeson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping one sheet from calculating
On Jun 27, 10:32*am, Xt wrote:
Hi folks. Is there a way to turn the calculation of a particular sheet off and on using VBA while the VBA is working with data from another sheet? Thanks xt Hi! First use this "Application.Calculation = xlCalculationManual" and in End "Calculate" Hope it will help! ~jaeson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping one sheet from calculating
On Jun 26, 7:32*pm, Xt wrote:
Is there a way to turn the calculation of a particular sheet off and on using VBA while the VBA is working with data from another sheet? No. Automatic v. manual calculation mode applies to the entire workbook, not individual sheets. In fact, I believe it applies to all workbooks open in the same Excel instance. However, after setting Application.Calculation=xlCalculationManual, you can use Sheets("sheet1").Calculate to cause one worksheet to recalculate. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping one sheet from calculating
Depends on the version of excel you're running.
Look in VBA's help for EnableCalculation. If you find it (and all the versions of excel that you need to support have it!), then read the help. On 06/26/2011 21:32, Xt wrote: Hi folks. Is there a way to turn the calculation of a particular sheet off and on using VBA while the VBA is working with data from another sheet? Thanks xt -- Dave Peterson |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Stopping one sheet from calculating
On Jun 30, 11:20*pm, Dave Peterson wrote:
Depends on the version of excel you're running. Look in VBA's help for EnableCalculation. If you find it (and all the versions of excel that you need to support have it!), then read the help. On 06/26/2011 21:32, Xt wrote: Hi folks. Is there a way to turn the calculation of a particular sheet off and on using VBA while the VBA is working with data from another sheet? Thanks xt -- Dave Peterson Thanks to you all. Very helpful. xt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a time sheet? | Excel Worksheet Functions | |||
Sheet has stopped calculating... | Excel Discussion (Misc queries) | |||
Stopping A Sheet From Scrolling | New Users to Excel | |||
Auto Calculating Time Sheet | Excel Worksheet Functions | |||
Calculating an AVG from data on another sheet | Excel Worksheet Functions |