question about "swtich" function

  • Thread starter Thread starter youngman
  • Start date Start date
Y

youngman

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
 
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
 
Well, color me embarassed...of course I could have looked in VBA, especially
since this is the .programming group...

Thanks, Tom -

-Frank
 
Back
Top