Business Solutions VBA and Macros for Microsoft® Office Excel® 2007

Chapter 4. User-Defined Functions

IN THIS CHAPTER

Creating User-Defined Functions	75
Custom Functions—Example and Explanation	76
Sharing UDFs	77
Useful Custom Excel Functions	78
Next Steps	100

Creating User-Defined Functions

Excel provides many built-in formulas, but sometimes you need a complex custom formula not offered—for example, a formula that sums a range of cells based on their interior color.

So, what do you do? You could go down your list and copy the colored cells to another section. Or, perhaps you have a calculator next to you as you work your way down your list—beware you don’t enter the same number twice! Both methods are time-consuming and prone to accidents. What to do? You could write a procedure—after all, that’s what this ...