| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| 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 | ||
| + | | 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 grids | | Refreshes all grids | ||
| + | | v7.0 | ||
|- | |- | ||
| − | | Application.CalculateFull | + | | {{Code|Application.CalculateFull}} |
| Force a calculate of XLCubed formulae | | Force a calculate of XLCubed formulae | ||
| + | | All | ||
|} | |} | ||
Revision as of 10:05, 7 April 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 grids | v7.0 |
| Application.CalculateFull | Force a calculate of XLCubed formulae | All |
