VBA: function and sub parameters

Optional parameters

The optional declaration of a parameter with byVal or byRef allows to pass a parameter by reference or as copied value.

When calling a function or sub, there are cases when parentheses are required or can be omited.

The paramArray keyword allows to pass an arbitrary number of arguments to a sub or function.