Working with Function Arguments

To work with functions, you need to understand how to work with arguments. The following points apply to the arguments for Excel worksheet functions and custom VBA functions:

1 Arguments can be cell references, variables (including arrays), constants, literal values, or expressions.

1 Some functions have no arguments.

1 Some functions have a fixed number of required arguments (from 1 to 60). 1 Some functions have a combination of required and optional arguments.

0 0

Post a comment