Page 402 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 379

Syntax: Function name(argument7 ,. . . Optional argument)
See also: Function, ParamArray

Or Operator
Logical operator. (expression1 Or expression2) evaluates to True if either
expression1 or expression2 is True. Also can be used to perform bitwise
comparison of two numerical values: (13 Or 6) evaluates to 15. (1 3 = 00001 101, 6 =
000001 10,15 = 00001 11 1).
See also: Or, Not, Xor
Param Array Keyword
Allows the use of an indefinite number of arguments for a function. The
argument becomes an array of Variant elements. The array has lower array index
of zero, even if Option Base 1 is declared.
Syntax: Function name(afgument7,. .. ParamArray argument() As Variant)
Example: Function test (ParamArray rng() As Variant)
See also: Dim, Function, Variant

Paste Method
Pastes the contents of the Clipboard onto a worksheet.
Syntax: object. Paste (destination)
Object must be Worksheet. There are other Paste methods, with different syntax,
for Chart and many other objects. Destination specifies the range where the copy
will be pasted. If omitted, copy is pasted to the current selection.
Example: Worksheets("Sheet1 ").Range("Al :C5O).Copy
Actives heet.Paste
See also: Copy, Cut

Preserve Command
Preserves data in an existing array when using ReDim.

Private Command
Indicates that the procedure is available only to procedures in the same module.

Public Command
Indicates that the procedure is available to all other procedures.

Quit Method
Quits Microsoft Excel.
Syn fax: object. Qu i t
Object must be Application.
Example: Application.Quit
See also: Close, Save
Range Method
Returns a Range object that represents a cell or range of cells.
Syntax: object,Range(reference)
Object is required if it is Worksheet. Reference must be an Al-style reference, in