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

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

I think what you need is the keyword Optional:

Function Jim(a,b,c,Optional d,Optional e,Optional f)

RBS


"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