UndoCompareModifications

Removes any rows and columns that have been inserted to align a worksheet by previous use of the OAK's workbook/worksheet Compare facilities (either through the OAK user interface or by the VBA method)).

Applies to

IOAKAddIn, IOAKAPI

SYNTAX

result1 = expression1.UndoCompareModifications

expression2.UndoCompareModifications(bookOrSheet)

expression1   Required.  An expression that returns an IOAKAddIn object.

expression2   Required.  An expression that returns an IOAKAPI object.

result1   An OAKResult enumeration indicating the success or otherwise of the action.

BookOrSheets        Required.  One of

•an Excel workbook object

•an Excel worksheet object

•a collection of worksheet objects

•an array of worksheet objects

Remarks

When applied to an IOAKAddIn object, the UndoCompareModifications method activates the same dialog box as is presented when the Remove compare modifications is selected manually from the OAK user interface.  The action that follows is controlled by the data gathered by the dialog box from the user.

When applied to an IOAKAPI object, the UndoCompareModifications method the workbook or worksheets to be changed are specified by the parameter submitted to the method.