XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Macros

Revision as of 12:32, 4 November 2011 by NMaudgil (talk | contribs)

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.