I inherited a VB macro which contains both calculate and calculatefullrebuild statements.
I converted them all to calculate and I wasn't getting the correct answers when I ran the macro. I also tried calculatefull and still did not get the correct answers in my workbook.
Only when I use calculatefullrebuild do I get the correct answers. the only problem is that the calculatefullrebuild statement really slows down my macro. And a task which used to take me 15 minutes to run, can take 2x 3x
What is the difference between calculate and calculatefullrebuild?
Also, how can I reduce the processing time?
Thanks in advance
I converted them all to calculate and I wasn't getting the correct answers when I ran the macro. I also tried calculatefull and still did not get the correct answers in my workbook.
Only when I use calculatefullrebuild do I get the correct answers. the only problem is that the calculatefullrebuild statement really slows down my macro. And a task which used to take me 15 minutes to run, can take 2x 3x
What is the difference between calculate and calculatefullrebuild?
Also, how can I reduce the processing time?
Thanks in advance