Page 408 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 385

Variant Data Type
Use to declare a variable's type as Variant, either in a Dim statement, or in a Sub
or Function statement. Variant is the default data type, so usually not required. It
is required when using the ParamArray keyword. Sixteen bytes + one
bytekharacter required per variable.
Example: Function test (ParamArray rng() As Variant)
See also: Dim, As, Boolean, Double, Integer, String
Wend Command
Delineates the end of a While ... Wend procedure.
Syntax: See explanation under Do ... Loop.
See also: Do ... Loop, While ... Wend

While ... Wend Command
Executes a series of statements as long as a specified condition is true.
Syntax: See explanation under Do ... Loop.
See also: Do ... Loop, Wend

With ... End With command
Delineates a block of statements to be executed on a single object.
Syntax: With object
(statements)
End With
See also: Do ... Loop, While ... Wend

XOr Operator
Exclusive Or operator.
Use to perform bitwise comparison of two numerical values: (1 3 XOr 6) evaluates
to 11. (13 = 00001101,6 = 00000110, 11 = 00001011).
See also: Or, Not, Or