| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
ActiveSheet.Calculate not calculating
I am using ActiveSheet.Calculate in a Macro to calculate the activesheet. The
Macro has 400lines and every line is perfectly exceuted. One Worksheet has complex Index formula (array function) that refers to a large database of 30000 lines. After the Macro execution , I find the sheet has not been calculated. I had to manually do it using Shift+F9. Wht is it happening |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't get ActiveSheet to work... | Excel Discussion (Misc queries) | |||
| ActiveSheet.Paste (error) | Excel Worksheet Functions | |||
| ActiveCell or ActiveSheet | Excel Worksheet Functions | |||
| ActiveSheet.Paste - Error help? | Excel Discussion (Misc queries) | |||
| Waiting for "Calculating Cells" when there is little to calculate | Excel Discussion (Misc queries) | |||
Threaded Mode
