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/