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

Macros

Revision as of 12:17, 4 November 2011 by NMaudgil (talk | contribs) (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 ...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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.

  • 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.