Select Case limits

  • Thread starter Thread starter KRosier
  • Start date Start date
K

KRosier

Is there a limit to the number of "Case"s that I can have in a Select
Case statement?

I have 100 Ranks ranging from rank 1.1 through rank 12.0 with values
between 0 and 23,308,097. For example:

Case 7125 To 61,749
Rank=2
Case 61,750 To 192,850
Rank=3

I thought I'd use a global module with the Select Case statement in it
so that I could call it whenever/wherever I needed it.

Is this the best/most efficient way to do this or am I overlooking
something?

Thank you for your help.

Kathy
 
If you mean relation as in are these numbers in tables and are they
related, then no. If that's not what you were referring to please
explain what you mean by "relation"

Thanks!
 
I see what you mean. I'm sure for the first 90 ranks there must be, but
it is not immediately visible (at least to these eyes that have been out
of school for a good many years). The database is for a guild from a
game that I play. I will check around to see if anyone knows the
formula. A formula would certainly be the way to go if I can find it.
In the meantime, is there a limit to the number of "cases" I can have?

Kathy
 
Back
Top