Page 203 - Excel Progamming Weekend Crash Course

k540629 ch14.qxd 9/2/03 9:34 AM Page 178

178 Saturday Afternoon

Figure 14-4 Cell data can be oriented at various angles.

If you change the orientation of cell data, Excel will not automatically
increase the row height to fit the new orientation. You’ll have to do that
Note manually.

Cell Borders
Excel can display borders around individual cells or groups of cells. For ranges of two or
more cells, the borders can be around the outer edges only or can include the boundaries
between cells within the range as well. Any Range object has a Borders collection that
contains the borders for that range. Each individual border is represented by a Border
object. Each border has an associated constant, as described in Table 14-3.

Table 14-3 Range Borders and the Associated Constants
Border Constant
Bottom edge of range xlEdgeBottom

Top edge of range xlEdgeTop
Left edge of range xlEdgeLeft
Right edge of range xlEdgeRight

Vertical borders inside the range xlInsideVertical
Horizontal borders inside the range xlInsideHorizontal