| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| Line 19: | Line 19: | ||
|- | |- | ||
| {{Code|Application.Run "XL3RefreshAllTables"}} | | {{Code|Application.Run "XL3RefreshAllTables"}} | ||
| − | | Refreshes all | + | | Refreshes all tables |
| v7.0 | | v7.0 | ||
|- | |- | ||
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 |
