| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
(Created page with "The following XLCubed macros can be called from VBA: *Application.Run "XL3RefreshGrid","Sheet1!a1" As you can see in the example you need to include an address for the grid is ...") |
|||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
The following XLCubed macros can be called from VBA: | The following XLCubed macros can be called from VBA: | ||
| − | + | {| class="wikitable" | |
| − | + | ! Code | |
| − | + | ! Description | |
| − | + | ! Introduced | |
| − | + | |- | |
| − | + | | 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 tables | ||
| + | | v7.0 | ||
| + | |- | ||
| + | | {{Code|Application.CalculateFull}} | ||
| + | | 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 |
