Hi
have a look at 'Optional' in the VBA help

--
Regards
Frank Kabel
Frankfurt, Germany

"y" schrieb im Newsbeitrag
...
Does VBA allow declaration of function which the user doesn't specify
all the parameters for?

Example:
Area("Triangle",sideA,sideB,sideC)
Area("Rectangle",sideA,sideB) OR Area("Rectangle",sideA,sideB;)
Area("Square",side) OR Area("Square",side;;)

Thanks, Alex.