| 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 ...") |
|||
| Line 3: | Line 3: | ||
*Application.Run "XL3RefreshGrid","Sheet1!a1" | *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 | + | 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” | ||
Revision as of 12:18, 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.
