Look up ParamArray in help, and this previous post http://tinyurl.com/c65h3

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"adamaagard" wrote in message
...
What is the syntax for declaring variabls in VBA functions that may or may
not be filled?

Example:

Function Jim(a,b,c,?,?,?) where ? are variables that may or may not be
filled

Thanks