Page 404 - Excel for Scientists and Engineers: Numerical Methods

APPENDIX 1 SELECTED VISUAL BASIC KEYWORDS 381

changes the interior color of the active cell to yellow if it is in row 10.
See also: Column, Columns, Rows

RowHeight Property
Returns or sets the height of all rows in the range.
Example: Worksheet@ heet 1 ").Rows( 1 ).RowHeig ht = 15
See also: ColumnWidth

Rows Method
Returns a Range object that represents a single row or multiple rows.
Syntax: object.Rows(index)
Object can be Worksheet or Range. Index is the name or number of the row.
Example: Selection.Rows.Count returns the number of rows in the selection.
See also: Columns, Range

RTrim Function
Returns a string without trailing spaces.
Syntax: RTrim(string)
See also: LTrim, Trim

Save Method
Saves changes to active workbook.
Syntax: objectSave(fi1ename)
Object must be Workbook. If filename is omitted, uses a default name.
Example: ActiveWorkbook.Save
See also: Close, Open, SaveAs

SaveAs Method
Saves changes to active workbook or other document with a different filename.
Syntax: object.SaveAs(filename, . . .)
Object can be Worksheet, Workbook, Chart or other document types. See
Microsoft ExceWVisual Basic Reference or On-Line Help for details.
Example: NewChart.SaveAs("New Chart")
See also: Close, Open, Save

Select Method
Selects an object.
Syntax: object.Select
Object can be Chart, Worksheet or one of many other objects.
Example: Range("A1 :CSO").Select
See also: Activate

Select Case Command
Executes one of several blocks of statements, depending on the value of an
expression.
Syntax: Select Case expression
Case expression 1