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

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

Hi

According to Excel VBA help files :

Switch(expr-1, value-1[, expr-2, value-2 … [, expr-n,value-n]])

the Switch function can have unlimited number of arguments but there is
probably a limit depending on your computer's available memory.

I search the Knowledge Base and found nothing on Maximum Arguments in
functions.

Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Well, color me embarassed...of course I could have looked in VBA, especially
since this is the .programming group...

Thanks, Tom -

-Frank

"tomhaddock" wrote in message
...
Hi

According to Excel VBA help files :

Switch(expr-1, value-1[, expr-2, value-2 . [, expr-n,value-n]])

the Switch function can have unlimited number of arguments but there is
probably a limit depending on your computer's available memory.

I search the Knowledge Base and found nothing on Maximum Arguments in
functions.

Tom



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/