Page 401 - Excel for Scientists and Engineers: Numerical Methods

378 EXCEL: NUMERICAL METHODS

NumberFormat Property
Returns or sets the number format code of a cell.
Example: Range("A1 :AlO).NumberFormat= "0.00 sets the number format of the
specified range of cells.
See also: GoSub, GoTo, Return, Select Case

On ... GoTo Command
Branches to one of several specified lines, depending on the value of an
expression.
Syntax: On expression GoTo label?, ...
See explanation under On ... GoSub command.
Example: See examples of On ... GoTo procedures in Chapter 2.
See also: GoSub, GoTo, Return, Select Case

On Error GoTo Command
Enables an error-handling routine and specifies the action to be taken in event of
an error.
Examples: On Error GoTo line (enables the error-handling routine at the specified
location in the procedure)
On Error Resume Next (execution resumes with the statement
immediately following the statement that caused the error)
On Error GoTo 0 (disables any enabled error handler in the current
procedure)

Open Method
Opens a workbook.
Syntax: object.Open(filename, .. .)
Object must be Workbooks. Filename is required. See On-Line Help for the
remaining arguments.
Example: Workbooks.Open("S0LVSTAT.XLS)
See also: Close, Save, SaveAs

Option Base Keyword
Use at module level to declare lower bound for an array.
Can be Option Base 0 or 1. The statement can appear only once in a module and
must precede all Dim or equivalent declaration.
See also: Dim, LBound, ReDim

Option Explicit Statement
Use at module level to force explicit declaration of all variables in that module.
See also: Option Base, Option Compare
Optional Keyword
Indicates that an argument in a function is not required. All arguments following
the Optional keyword must be optional. All optional arguments are Variant.