O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Understanding Custom Function Rules

A custom function must start with a Function statement and end with an End Function statement. In addition to the function name, the Function statement usually specifies one or more arguments. You may include as many as 29 arguments, using commas to separate them. You can also create a function with no arguments. Excel includes several built-in functions— RAND() and NOW(), for example—that don't use arguments. As you'll see later in this chapter, you can also create functions with optional arguments—arguments that you can either include or omit when you call the function.

Following the Function statement, a function procedure includes one or more VBA statements that make decisions and perform calculations using ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required