19.1. The Range Object as a Collection19.2. Defining a Range Object19.2.1. Range Property19.2.2. Cells Property19.2.3. Column, Columns, Row, and Rows Properties19.2.4. Offset Property19.3. Additional Members of the Range Object19.3.1. Activate Method19.3.2.
AddComment Method19.3.3. Address Property (Read-Only String)19.3.4.
AutoFill Method19.3.5. AutoFilter Method19.3.6.
AutoFit Method19.3.7.
AutoFormat Method19.3.8.
BorderAround Method19.3.9. Calculate Method19.3.10. Clear Methods19.3.11. ColumnDifferences and RowDifferences Methods19.3.12. ColumnWidth and RowHeight Properties19.3.13. Width, Height, Top, and Left Properties19.3.14.
Consolidate Method19.3.15. Copy and Cut Methods19.3.16. CopyFromRecordset Method19.3.17.
CreateNames Method19.3.18. CurrentRegion Property19.3.19.
Delete Method19.3.20. Dependents and DirectDependents Properties19.3.21. Precedents and DirectPrecedents Properties19.3.22. End Property19.3.23. EntireColumn and EntireRow Properties19.3.24.
Fill Methods19.3.25. Find Method19.3.26. FindNext and FindPrevious Methods19.3.27. Formula and FormulaR1C1 Properties19.3.28. FormulaArray Property19.3.29. FormulaHidden Property (R/W Boolean)19.3.30. HasFormula Property (Read-Only)19.3.31. HorizontalAlignment Property19.3.32. IndentLevel Property and
InsertIndent Method19.3.33.
Insert Method19.3.34.
Locked Property19.3.35. Merge-Related Methods and Properties19.3.36. Next and Previous Properties19.3.37.
NumberFormat Property 19.3.38.
Parse Method19.3.39.
PasteSpecial Method19.3.40. PrintOut Method19.3.41.
PrintPreview Method19.3.42.
Replace Method19.3.43.
Select Method19.3.44.
ShrinkToFit Property19.3.45. Sort Method19.3.46.
SpecialCells Method19.3.47.
TextToColumns Method19.3.48. Value Property19.3.49.
WrapText Property19.4. Children of the Range Object19.4.1. The Areas Collection19.4.2. The Borders Collection19.4.3. The Border Object19.4.3.1. Color property19.4.3.2.
ColorIndex property19.4.3.3. LineStyle property19.4.3.4.
Weight property19.4.4. The Characters Object19.4.5. The Comment Object19.4.6. The Font Object19.4.7. The FormatConditions Collection19.4.8. The Interior Object19.4.8.1.
Color and ColorIndex properties19.4.8.2. Pattern property19.4.8.3.
PatternColor and PatternColorIndex properties19.4.9. The PivotField, PivotItem, and PivotTable Objects19.4.10. The QueryTable Object19.4.11. The Validation Object19.5. Example: Getting the Used Range19.6. Example: Selecting Special Cells19.6.1. Designing the Utility19.6.2. Designing the Dialog19.6.2.1. The Frame control19.6.2.2. Control names19.6.2.3. Tab Order19.6.2.4. Some final tips19.6.3. Writing the Code