Page 175 - Excel Progamming Weekend Crash Course

k540629 ch11.qxd 9/2/03 9:34 AM Page 150

150 Saturday Afternoon

REVIEW
A worksheet is composed of cells arranged in rows and columns. In this session, you learned
about some of the tools available to the Excel programmer for working with cells, rows, and
columns.
The Cells property enables you to access single cells within a range or worksheet.
The SpecialCells methods allows you to select cells from a range based on their
content, such as number cells or formula cells.
Use the Columns and Rows properties to refer to the columns or rows in a work-
sheet or range.
The EntireRow and EntireColumn properties enables you to refer to the full rows
or columns that are spanned by a range.
Use the EntireRow and EntireColumn properties to add or delete rows and
columns from the worksheet.

QUIZ YOURSELF
1. When used without an argument, what does the Cells property reference? (See
the “Referencing All Cells” section.)
2. Which method would you use to access only those cells in a range that contain
comments? (See the “The SpecialCells Method” section.)
3. Range r1 refers to cells B1:C1. Does r1.Columns refer to all of columns B and C?
(See the “Manipulating Columns and Rows” section.)
4. Range r1 refers to cells A2:A4. To what does r1.EntireRow refer? (See the
“Referencing Entire Rows and Columns” sidebar.)
5. You insert a new worksheet column at position B. What happens to data in the
original column B? (See the “Adding and Deleting Rows and Columns” section.)