| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| Line 4: | Line 4: | ||
*Application.Run "XL3RefreshGrid","Sheet1!a1" | *Application.Run "XL3RefreshGrid","Sheet1!a1" | ||
| − | + | When using XL3RefreshGrid you need to include an address for the grid is to be refreshed, in Sheet1 at cell A1 | |
Revision as of 12:33, 4 November 2011
The following XLCubed macros can be called from VBA:
- Application.Run "XL3RefreshGrid","Sheet1!a1"
When using XL3RefreshGrid 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.
