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:
+
{| class="wikitable"
 
+
| width="200" | | width="400" [[Application.Run "XL3RefreshGrid","Sheet1!a1"]]
 
+
| Include an address for the grid is to be refreshed
*Application.Run "XL3RefreshGrid","Sheet1!a1"
+
|-
 
+
| [[Application.Run “XL3RefreshAllGrids”]]
When using XL3RefreshGrid you need to include an address for the grid is to be refreshed, in Sheet1 at cell A1
+
| Refreshes all grids
 
+
|-
 
+
| [[Application.CalculateFull]]
 
+
| Force a calculate of XLCubed formulae.
*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.
 

Revision as of 12:43, 4 November 2011

| width="400" Application.Run "XL3RefreshGrid","Sheet1!a1" Include an address for the grid is to be refreshed
Application.Run “XL3RefreshAllGrids” Refreshes all grids
Application.CalculateFull Force a calculate of XLCubed formulae.