Page 399 - Excel for Scientists and Engineers: Numerical Methods

376 EXCEL: NUMERICAL METHODS

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), LBound(table,l) returns 1, LBound(table,2) returns 0.
See also: Dim, UBound

LCase Function
Converts a string into lowercase letters.
Syntax: LCase (string)
See also: UCase

LTrim Function
Returns a string without leading spaces.
Syntax: LTrim (string)
See also: RTrim

Left Function
Returns the leftmost characters of a string.
Syntax: Left(string,number)
If number is zero, a null string is returned. If number is greater than the number of
characters in string, the entire string is returned.
Example: Left("CHEMISTRY",4) returns CHEM
See also: Len, Mid, Right

Len Function
Returns the length (number of characters) in a string.
Syntax: Len(string)
Example: Len("CHEM1STRY") returns 9.
See also: Left, Mid, Right

Log Function
Returns the natural (base-e) logarithm of a number.
syntax: Log(numbe0
Number must be a value or expression greater than zero. VBA does not provide
base- 10 logarithms; use Log(value)/Log(l 0).
See also: Exp

Macrooptions Method
Sets options in the Macro Options dialog box.
Syntax: Application.MacroOptions(macro, description, hasMenu, menuText,
hasShortcutKey, shortcutKey, category, statusbar, helpContext, helpfile)
macro is the name of the macro. description is the description that appears in the
dialog box. category is the function category that the macro appears in: Financial, 1;
Date & Time, 2; Math & Trig, 3; Statistical, 4; Lookup & Reference, 5;