You can use named argument or you can provide the arguments in an ordered,
comma separated list.

As far as I know, there is no function that requires one or the other - the
each will accept either.

by using a named list, you don't have to remember the order and you don't
have to supply optional arguments (or mark their position).

--
Regards,
Tom Ogilvy

Mo wrote in message
om...
This is just a matter of personal style and idle curiousity. Why is
it that some functions need a parameter list like "Whe=" inside the
brackets and others you just specify the parameter like
"xlColumnClustered". I guess my question is what is the purpose of
the ":=" and is there a workaround so the parmeter list looks like
Function(arg1, arg2,...) instead of Function(Whe=arg1,
Location:=arg2,...)

Any help would be appreciated...Mo.