| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| Line 3: | Line 3: | ||
{| class="wikitable" | {| class="wikitable" | ||
| width="400" | Application.Run "XL3RefreshGrid","Sheet1!a1" | | width="400" | 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, in example grid is on Sheet 1 at cell A1 |
|- | |- | ||
| Application.Run “XL3RefreshAllGrids” | | Application.Run “XL3RefreshAllGrids” | ||
Revision as of 12:51, 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, in example grid is on Sheet 1 at cell A1 |
| Application.Run “XL3RefreshAllGrids” | Refreshes all grids |
| Application.CalculateFull | Force a calculate of XLCubed formulae. |
