| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| (2 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
{| class="wikitable" | {| class="wikitable" | ||
| − | + | ! Code | |
| − | + | ! Description | |
| + | ! Introduced | ||
|- | |- | ||
| − | | Application.Run | + | | width="400" | {{Code|Application.Run "XL3RefreshGrid", "Sheet1!A1"}} |
| + | | width="400" | Include an address for the Grid to be refreshed | ||
| + | | v6.1 | ||
| + | |- | ||
| + | | {{Code|Application.Run "XL3RefreshAllGrids"}} | ||
| Refreshes all grids | | Refreshes all grids | ||
| + | | v6.0 | ||
| + | |- | ||
| + | | {{Code|Application.Run "XL3RefreshTable", "Sheet1!A1"}} | ||
| + | | Include an address for the Table to be refreshed | ||
| + | | v7.1 | ||
| + | |- | ||
| + | | {{Code|Application.Run "XL3RefreshAllTables"}} | ||
| + | | Refreshes all tables | ||
| + | | v7.0 | ||
|- | |- | ||
| − | | Application.CalculateFull | + | | {{Code|Application.CalculateFull}} |
| − | | Force a calculate of XLCubed formulae | + | | Force a calculate of XLCubed formulae |
| + | | All | ||
|} | |} | ||
Latest revision as of 14:09, 8 May 2014
The following XLCubed macros can be called from VBA:
| Code | Description | Introduced |
|---|---|---|
| Application.Run "XL3RefreshGrid", "Sheet1!A1" | Include an address for the Grid to be refreshed | v6.1 |
| Application.Run "XL3RefreshAllGrids" | Refreshes all grids | v6.0 |
| Application.Run "XL3RefreshTable", "Sheet1!A1" | Include an address for the Table to be refreshed | v7.1 |
| Application.Run "XL3RefreshAllTables" | Refreshes all tables | v7.0 |
| Application.CalculateFull | Force a calculate of XLCubed formulae | All |
