| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Activesheet.Calculate failing to calculate
At some stage during my macro, I have the line "Activesheet.Calculate"
Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9 doesn't work either. I've played around with Activesheet.EnableCalculation, without success. F9 does recalculate the page, but I don't want to use this when I only want one sheet calculated. Thanks in advance Daniel |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Activesheet.Calculate failing to calculate
Is the correct sheet "Active". Maybe you need to activate the sheet you want
first. -- JNW "Daniel Bonallack" wrote: At some stage during my macro, I have the line "Activesheet.Calculate" Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9 doesn't work either. I've played around with Activesheet.EnableCalculation, without success. F9 does recalculate the page, but I don't want to use this when I only want one sheet calculated. Thanks in advance Daniel |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Activesheet.Calculate failing to calculate
Hi, yes, life would be simple if the answer were that easy...
"JNW" wrote: Is the correct sheet "Active". Maybe you need to activate the sheet you want first. -- JNW "Daniel Bonallack" wrote: At some stage during my macro, I have the line "Activesheet.Calculate" Unfortunately, it fails to calculate anything. Returning to Excel, Shift+F9 doesn't work either. I've played around with Activesheet.EnableCalculation, without success. F9 does recalculate the page, but I don't want to use this when I only want one sheet calculated. Thanks in advance Daniel |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i calculate a % | Excel Worksheet Functions | |||
| ActiveSheet.Calculate not calculating | Excel Discussion (Misc queries) | |||
| calculate time does not calculate | Excel Discussion (Misc queries) | |||
| Copying new activesheet after other activesheet is hidden? | Excel Programming | |||
| Macro that hide or unhide and not calculate or calculate | Excel Programming | |||
Linear Mode
