If you are referring to the CHOOSE function, the limit is 29 values. I don't
see a function called "switch" in my XL97 or XL XP installs.
--
HTH -

-Frank
Microsoft Excel MVP
Dolphin Technology Corp.
http://vbapro.com



"youngman" wrote in message
...
hi,

here is a question about "swtich" function.

i wonder if there is a limit for the quantity of the arguments in the
function.

thank you.

regards