CopyLiteral

Copies the formula(s) from the source range to the target range, without adjusting cell coordinates as Excel normally does.

(More accurately: when Excel copies formulas, it preserves them in R1C1 notation, which has the effect of causing them to change when shown in A1 notation.  OAK's Copy literal command preserves them in A1 notation, which has the effect of causing them to change when shown in R1C1 notation.)

Applies to

IOAKAddIn, IOAKAPI

SYNTAX

result = expression1.CopyLiteral

expression2.CopyLiteral (source, target)

expression1   Required.  An expression that returns an IOAKAddIn object.

expression2   Required.  An expression that returns an IOAKAPI object.

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

source        Required Range.  The cells to be copied.

target   Required Range.  The place where the cells are to be copied to.

Remarks

When applied to an IOAKAddIn object, the CopyLiteral method acts on the current selection in the same way as the Copy literal command does. An exception may be raised if the selection is not suitable for the action.

When applied to an IOAKAPI object, the CopyLiteral method acts on the ranges indicated by the parameters submitted to the method.