If you are using VBA with Excel to do any looping round dimensions or subsets then its a good idea to use the M_Clear macro to clear the memory on the client side.
For example if I execute a TI process through VBA and the TI process updates a subset, if I then try to loop round that subset in VBA code I might get wierd results.
This is where I would use Application.Run("M_Clear") to clear the memory on the client side.
