Page 391 - Excel for Scientists and Engineers: Numerical Methods

368 EXCEL: NUMERICAL METHODS

does not save changes; if omitted, displays a "Save Changes?" dialog box.
Example: Workbooks("BOOK1 .XLS").Close
See also: Open, Save, SaveAs

Column Property
Returns a number corresponding to the first column in the range. Read-only.
Syntax: object.Column
Object must be Range.
See also: Columns, Row, Rows
Columns Method
Returns a Range object that represents a single column or multiple columns
Syntax: objectColumns(index)
Object can be Worksheet or Range. lndex is the name or number (column A = 1,
etc.) of the column.
Example: Selection.Colurnns.Count returns the number of columns in the selection.
See also: Range, Rows

ColumnWidth Property
Returns or sets the width of all columns in the range. If columns in the range
have different widths, returns Null.
Example: Worksheets("Sheetl").Columns("C").ColumnWidth = 30
See also: RowHeight

ConvertForrnula Method
Converts cell references between A 1 -style and R1 C 1 -style, and between absolute
and relative. On-Line Help states that Formula must begin with an equal sign, but
references in a string that does not begin with an equal sign are also converted.
Syntax: expression.ConvertFormula(Formula, FromReferenceStyle,
ToReferenceStyle, ToAbsolute, RelativeTo)
Example:
Formulastring = Application.ConvertFormula(FormulaString, xlAl , xlAl , xlAbsolute)
See also: Address

Copy Method
Copies the selected object to the Clipboard or to another location.
Syntax: object.Copy(destination)
Object can be Range, Worksheet, Chart and many other objects. Destination specifies
the range where the copy will be pasted. If omitted, copy goes to the Clipboard.
Example: Worksheets("Sheet1 ").Range("Al :CBO).Copy
See also: Cut, Paste

Cos Function
Returns the cosine of an angle.
Syntax: Cos(nurnberj
Number is the angle in radians; it can be in the range --oo to +oo. To convert an angle
in degrees to one in radians, multiply by d180. Returns a value between -1 and 1.
See also: Atn, Sin, Tan