syntax for variable

[adamaagard]

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

[Bob Phillips]

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" <[email protected]> wrote in message
news:[email protected]...
> 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

[RB Smissaert]

I think what you need is the keyword Optional:

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

RBS


"adamaagard" <[email protected]> wrote in message
news:[email protected]...
> 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