Page 405 - Excel for Scientists and Engineers: Numerical Methods

3 82 EXCEL: NUMERICAL METHODS

(statements)
Case expression2
(statements)
End Select
You can also use the To keyword in expression, e.g., Case "A" To "M". Expression
can also be a logical expression. Use Case Else (not required) to handle all cases
not covered by the preceding Case statements.
Example: See examples of Select Case procedures in Chapter 2.
See also: If ... Then ... Else, On ... GoSub, On ... GoTo
Selection Property
Returns the selected object. The object returned depends on the type of selection,
See also: Activate, Activecell, Select

Set Command
Assigns an object reference to a variable.
See also: Dim, ReDim

Sgn Function
Returns the sign of a number.
Syntax: Sgn(numbe0
Returns 1, 0 or -1 if number is positive, zero or negative, respectively.
Example: Sgn(-7.3) returns -1.
See also: Abs

Sin Function
Returns the sine of an angle.
Syntax: Sin(numbe0
Number is the angle in radians; it can be in the range +XI to +a. To convert an angle
in degrees to one in radians, multiply by d180. Returns a value between -1 and 1.
See also: Atn, Cos, Tan

Sort Method
Sorts a range of cells.
Syntax: object.Sort(sortkeyl,orderl,sortkey2, orded, . . .)
Object must be Range. See Microsoft ExceWisual Basic Reference or On-Line
Help for details.

Sqr Function
Returns the square root of a number.
Syntax: Sqr(numbe0
Number must be greater than or equal to zero.

Step Keyword
Stops execution, but does not close files or clear variables.
See also: End