| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Macros"
| Line 1: | Line 1: | ||
The following XLCubed macros can be called from VBA: | 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 | 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” | *Application.Run “XL3RefreshAllGrids” | ||
You do not need to include an address when using XL3RefreshAllGrids. | You do not need to include an address when using XL3RefreshAllGrids. | ||
| + | |||
| + | |||
*Application.CalculateFull | *Application.CalculateFull | ||
Use CalculateFull to force a calculate of XLCubed formulae. | Use CalculateFull to force a calculate of XLCubed formulae. | ||
Revision as of 12:31, 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.
