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