Creating Worksheet Functions and Living to Tell about It

In This Chapter

^ Knowing why custom worksheet functions are so useful ^ Exploring functions that use various types of arguments ^ Understanding the Paste Function dialog box for many people, VBA's main attraction is the capability to create custom worksheet functions — functions that look, work, and feel just like those that Microsoft built into Excel. A custom function offers the added advantage of working exactly how you want it to. I introduce custom functions in Chapter 5. In this chapter, I get down to the nitty-gritty and describe some tricks of the trade.

0 0

Post a comment