| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| Line 2: | Line 2: | ||
| − | + | *Application.Run "XL3RefreshGrid","Sheet1!a1" | |
As you can see in the example you need to include an address for the grid is to be refreshed, in Sheet1 at cell A1 | As you can see in the example you need to include an address for the grid is to be refreshed, in Sheet1 at cell A1 | ||
Revision as of 12:32, 4 November 2011
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 to be refreshed, in Sheet1 at cell A1
- Application.Run “XL3RefreshAllGrids”
You do not need to include an address when using XL3RefreshAllGrids.
- Application.CalculateFull
Use CalculateFull to force a calculate of XLCubed formulae.
