Hey guys

Is there a limit on the amount of cases you can have in a
case statement?


Thanks in advance
Todd

Hi
AFAIK no: there's no limit

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
Hey guys

Is there a limit on the amount of cases you can have in a
case statement?


Thanks in advance
Todd

What is the function you are aiming for? Depending on that you may b
going about this the wrong way... Just a thought...

In the meantime, like this

Select Case ComboBox1.Value
Case 1
{DoStuff}
...
Case 52
{doStuff}
End Selec

--
Message posted from http://www.ExcelForum.com

If you ask this question, there is probably a better way to do what you
want. No way of knowing, but if there is a definable pattern or a way to
calculate things, it might be advisable.

--
Regards,
Tom Ogilvy

"Frank Kabel" wrote in message
...
Hi
AFAIK no: there's no limit

--
Regards
Frank Kabel
Frankfurt, Germany


Todd Huttenstine wrote:
Hey guys

Is there a limit on the amount of cases you can have in a
case statement?


Thanks in advance
Todd

Hey thanx to all who reponded. I ended up making a loop
which was much more practical.


-----Original Message-----
Hey guys

Is there a limit on the amount of cases you can have in a
case statement?


Thanks in advance
Todd
.