Page 19 - Excel Progamming Weekend Crash Course

540629 FM.qxd 9/2/03 4:10 PM Page xvi

xvi Contents

The Mid Statement ............................................................................118
Other String Functions .......................................................................119
SESSION 10–Using Ranges and Selections ...................................................121
The Range Object ................................................................................121
Manipulating Ranges .........................................................................122
Relative Ranges ................................................................................123
Other Range References ......................................................................127
Working with Comments .....................................................................128
Range Columns, Rows, and Size ............................................................130
Reading Data from Ranges ...................................................................130
Naming Ranges ..................................................................................132
The Selection Property ........................................................................134

PART II–Saturday Morning Part Review .....................................................137
Saturday Afternoon ............................................................................140
SESSION 11–Working with Columns, Rows, and Cells ....................................141
Referencing Cells with the Cells Property ................................................141
Referencing All Cells ..........................................................................142
Referencing by Row and Column ...........................................................142
Referencing by Cell Position ................................................................145
The SpecialCells Method .......................................................................145
Manipulating Columns and Rows ...........................................................147
Adding and Deleting Rows and Columns .................................................149
SESSION 12–Programming with Custom Formulas ........................................151
Cell References in Formulas ..................................................................151
Relative Cell References ......................................................................152
Absolute Cell References .....................................................................152
Named Range References ....................................................................154
Referencing Cells in Other Worksheets and Workbooks ................................155
Operators ..........................................................................................156
Mathematical Operators ......................................................................156
Comparison Operators ........................................................................156
Logical Operators ..............................................................................156
Avoiding Circular References ................................................................157
Controlling Formula Calculation ............................................................158
SESSION 13–Programming with Excel’s Built-In Functions ............................161
Excel’s Built-in Functions .....................................................................161
Using Excel Functions in Formulas .........................................................162
Excel Function Overview ......................................................................163
Financial Functions ...........................................................................163
Date and Time Functions ....................................................................166
Math and Trig Functions .....................................................................167
Text Functions .................................................................................168
The WorksheetFunction Object ..............................................................169