Page 394 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 371

sign is not necessary.
Example: F$ = "2*3
MsgBox Evaluate(F$)
See also: Formula

Exit Command
Exits a Do ..., For ..., Function ... or Sub ... structure.
Syntax: Exit Do, Exit For, Exit Function, Exit Sub
From a Do or For loop, control is transferred to the statement following the Loop
or Next statement, or, in the case of nested loops, to the loop that is one level
above the loop containing the Exit statement. From a Function or Sub procedure,
control is transferred to the statement following the one that called the procedure.
Example: See examples of Exit procedures in Chapter 2.
See also: Do, For ... Next, Function, Stop, Sub

Exp Function
Returns e raised to a power.
Syntax: Exp(nurnbefj
Returns the value of e raised to the power number.
See also: Log

False 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 SubFlag = False Then ...
See also: True

FillDown Method
Copies the contents and format(s) of the top cell(s) of a specified range into the
remaining rows.
Syntax: object. Fi II Down
Object must be Range.
Example: Worksheets("Sheetl2").Range("Al :A1 O).FillDown
See also: FillLeft, FillRight, FillUp in Excel's On-Line Help.

FillRight Method
Copies the contents and format(s) of the leftmost cell(s) of a specified range into
the remaining columns.
Syntax: object. FillDown
Object must be Range.
Example: Worksheets("Sheetl2").Range("Al :A1 O').FillRight
See also: FillDown, FillLeft, FillUp in Excel's On-Line Help.