Page 407 - Excel for Scientists and Engineers: Numerical Methods

3 84 EXCEL: NUMERICAL METHODS

True Keyword
Use the keywords True or False to assign the value True or False to Boolean
(logical) variables.
When other numeric data types are converted to Boolean values, 0 becomes False
while all other values become True. When Boolean values are converted to other
data types, False becomes 0 while True becomes -1.
Example: If FirstFlag = True Then GoTo 2000

UBound Function
Returns the upper limit of an array dimension.
Syntax: U Bound (array, dimension)
Array is the name of the array. Dimension is an integer (1,2,3, etc.) specifying the
dimension to be returned; if omitted, the value 1 is used.
Example: If the array table was dimensioned using the statement Dim table (1
To 3, IOOO), UBound(table,3) returns 1, UBound(table,2) returns 1000.
See also: Dim, LBound
UCase Function
Converts a string into upper case letters.
Syntax: UCase(string)
See also: LCase
Union Method
Returns a Range object that represents the union of two or more ranges, i.e.,
performs the same function as the comma character in the worksheet expression
SUM(A1, B2, C3).
Syntax: Union (rangel, range2)
See also: Intersect, Areas, Caller

Until Command
Optional part of Do ... Loop structure.
Syntax: See explanation under Do ... Loop.

Val Function
Converts a string to a number.
Syntax: Val (string)
Val stops at the first non-numeric character other than the period.
Example: Val("21 Lawrence Avenue") returns 2 1.
See also: Str

Value Property
Returns the value of an object.
Syntax: objecf.Value
If object is Range, returns or sets the value(s) of the cell(s). Read-write.
If Range contains more than one cell, returns an array of values.
Example: Worksheets("Sheetl2).Range("AI").Value = "Volume, mL"