Page 176 - Excel Progamming Weekend Crash Course
P. 176
k540629 ch12.qxd 9/2/03 9:34 AM Page 151
SESSION
12
Programming with Custom Formulas
Session Checklist
✔ Creating cell references in formulas
✔ Using absolute versus relative cell references
✔ Referring to named ranges in formulas
✔ Linking formulas to other worksheets and workbooks
✔ Using operators in Excel formulas
✔ Avoiding circular references
✔ Controlling formula calculation
n Excel program often needs to perform calculations, and the programmer has two
options in this regard. You can perform the calculations in VBA code using the opera-
A tors that were covered in Session 5, or you can perform the calculations in the Excel
worksheet by inserting formulas into worksheet cells. The latter approach is the topic of this
session.
Cell References in Formulas
An Excel formula almost always uses data that is located in other worksheet cells. To write
custom formulas, you need to understand how to reference these cells. There are three ways
to reference cells:
As a relative cell reference
As an absolute cell reference
As a named range
