CHAPTER 43
Creating Custom Worksheet Functions

---

IN THIS CHAPTER

• Getting an overview of VBA functions
• Looking at function procedures
• Focusing on function procedure arguments
• Debugging custom functions
• Pasting custom functions

---

As mentioned in the preceding chapter, you can create two types of VBA procedures: Sub procedures and Function procedures. This chapter focuses on Function procedures.

Introducing VBA Functions

Function procedures that you write in VBA are quite versatile. You can use these functions in two situations:

• You can call the function from a different VBA procedure.
• You can use the function in formulas that you create in a worksheet.

This chapter focuses on creating functions for use in your formulas.

Excel includes more than 450 predefined worksheet functions. With so many from which to choose, you may be curious as to why anyone would need to develop additional functions. The main reason is that creating a custom function can greatly simplify your formulas...