2 Replies Latest reply: Oct 22, 2013 6:17 PM by Nathan Simonson RSS

    Clear dimensions with expressions using macro

      Hi,

       

      I need to create a trigger which clears data in my straight table each time a selection in my multi box is made.

       

      I've implemented a macro with the following types of expressions:

       

           ActiveDocument.GetSheetObject("LB01").Clear

           ActiveDocument.GetSheetObject("CH01").ClearMemberFields

       

      My dimensions with dates have been edited to suit a particular format, and these dimensions are the only fields which don't get cleared when using the .ClearMemberFields command.

       

      Is there another command which clears dimensions which are expressions of the original fields?

       

      Thanks