Page 392 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 369

Count Property
Returns the number of items in the collection. Read-only.
Syntax: object.Count
Object can be any collection.
Example: The statement N = array.Count counts the number of values in the range
array.
Cut Method
Cuts the selected object and pastes to the Clipboard or to another location.
Syntax: 0bject.C ut( destination)
Object can be Range, Worksheet, Chart or one of many other objects. Destination
specifies the range where the copy will be pasted. If omitted, copy goes to the
C 1 ipboard.
Example: Works heets("S heet 1 "). Range("A1 :C50) .Cut
See also: Copy, Paste

CVErr Function
Returns a Variant containing an error value specified by the user.
Syntax: CVErr(numbe0
CVErr can return either Excel's built-in worksheet error values, or a user-defined
error value. The values of number for built-in worksheet error values are
xlErrDiv0, xlErrNA, xlErrName, xlErrNull, xlErrNum, xlErrRef, xlErrValue.
See also: IsError

Delete Method
Deletes the selected object.
Syntax: object.Delete(SH1FT)
Object can be Range, Worksheet, Chart and many other objects. SHIFT specifies
how to SHIFT cells when a range is deleted from a worksheet (xlToLeft or xlUp).
Can also use SHlFT = 1 or 2, respectively. If SHIFT is omitted, Excel moves
the cells without displaying the "SHIFT Cells?" dialog box.
Example: Worksheets("Sheetl2).Range("Al:AlO').Delete (xlToLeft) deletes the
indicated range and SHIFTS cells to left.

Dim Keyword
Declares an array and allocates storage for it.
Syntax: Dim variable (subscripts)
Variable is the name assigned to the array. Subscripts are the size dimensions of
the array; an array can have up to 60 size dimensions. Each size dimension has a
default lower value of zero; a single number for a size dimension is taken as the
upper limit. Use lower To upper to specify a range that does not begin at zero.
Use Dim with empty parentheses to specify an array whose size dimensions are
defined within a procedure by means of the ReDim statement.
Example: Dim Matrix (53) As Double creates a 6 x 6 array of double-precision
variables.
See also: ReDim