Serving the Quantitative Finance Community
Rebuild Dependency Tree (in Excel) using VBA
Manually, I can rebuild the Dependency Tree in Excel using CTRL+ALT+SHIFT+F9 (pressing these 4 keys together from the keyboard).How could I rebuild it automatically from VBA ?(Apart from using the SendKeys command, which might actually work too .. but will interfere in my working on the same PC on non-Excel applications).Thanks.
Rebuild Dependency Tree (in Excel) using VBA
I guess, I found it, myself. It could be done using:Application.CalculateFullRebuild