Page 403 - Excel for Scientists and Engineers: Numerical Methods

380 EXCEL: NUMERICAL METHODS

quotes, or the name of the reference.
Example: Worksheets("Sheetl2).Range("AI").Value = 5
See also: Cells

ReDim Keyword
Allocates or re-allocates dynamic array storage.
Syntax: ReDim variable (subscripts)
For discussion of variable and subscripts, see comments under the entry for Dim.
You can use ReDim repeatedly to change the number of elements in an array, or
the number or dimensions.
Example: Dim Matrix()
(statements)
ReDim Matrix (55)
(statements)
ReDim Matrix (1 5,25)
See also: Dim

Resume Command
Resumes execution after an error-handling routine is finished.
Examples: Resume 0
Resume Next (execution resumes with the statement immediately
following the statement that caused the error)
Resume label (Execution resumes at the specified location in the
procedure)
See also: On Error GoTo
Return Command
Delineates the end of a subroutine within a procedure.

Right Function
Returns the rightmost characters of a string.
Syntax: Right (string, number)
If number is zero, a null string is returned. If number is greater than the number of
characters in string, the entire string is returned.
Example: Right(303585842,4) returns 5842.
See also: Left, Len, Mid
Rnd Function
Returns a random number between 0 and 1.
Syntax: Rnd
Row Property
Returns a number corresponding to the first row in the range. Read-only.
Syntax: object.Row
Object must be Range.
Example: If ActiveCell.Row = 10 Then ActiveCell.lnterior.Colorlndex = 27