Page 398 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 375

Intersect Method
Returns a Range object that represents the intersection of two ranges.
Syntax: Intersect (rangel, range2)
See also: Union, Areas, Caller

IsArray Function
Returns True if the variable is an array.
Syntax: IsArray(name)
See also: other Is functions

IsDate Function
Returns True if the expression can be converted to a date.
Syntax: IsDate(expression)
See also: other Is functions

IsEmpty Function
Returns True if the variable has been initialized.
Syntax: Is Empty (expression)
See also: other Is functions

IsMissing Function
Returns True if an optional argument has not been passed to a procedure.
Syntax: IsMissing(name)
See also: other Is functions

IsNull Function
Returns True if the expression is null (i.e., contains no valid data).
Syntax: IsNull(expression)
See also: other Is functions

IsNumerie Function
Returns True if the expression can be evaluated to a number.
Syntax: IsNumeric(expression)
See also: other Is functions

Italic Property
Returns True if the font is Italic. Sets the Italic font. Read-write.
Syntax: objecf.ltalic
Object must be Font.
Example: Range("A1 :El").Font.ltalic = True makes the cells italic.
See also: Bold

LBound Function
Returns the lower limit of an array dimension.
Syntax: LBound(amy,dimension)
Array is the name of the array. Dimension is an integer (1,2, 3, etc.) specifying the