| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| Line 1: | Line 1: | ||
| − | |||
The following XLCubed macros can be called from VBA | The following XLCubed macros can be called from VBA | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | | width="200" | | + | | width="200" | Application.Run "XL3RefreshGrid","Sheet1!a1" |
| width="400" | Include an address for the grid is to be refreshed | | width="400" | Include an address for the grid is to be refreshed | ||
|- | |- | ||
| − | | | + | | Application.Run “XL3RefreshAllGrids” |
| Refreshes all grids | | Refreshes all grids | ||
|- | |- | ||
| − | | | + | | Application.CalculateFull |
| Force a calculate of XLCubed formulae. | | Force a calculate of XLCubed formulae. | ||
|} | |} | ||
Revision as of 12:48, 4 November 2011
The following XLCubed macros can be called from VBA
| Application.Run "XL3RefreshGrid","Sheet1!a1" | Include an address for the grid is to be refreshed |
| Application.Run “XL3RefreshAllGrids” | Refreshes all grids |
| Application.CalculateFull | Force a calculate of XLCubed formulae. |
