View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default CASE STATEMENTS

Dan,
Whilst 300+ compiles OK, I can't help thinking there must be a better way of
achieving it. There is a limit as the size of a module, 65K I believe, which
may be a problem if each case has much code.
Depends what you are trying to achieve.

NickHK

"DanielWalters6" wrote in message
...
I plan to create a big one, adding several cases from other people's code,
probably 300 case statements in total?

--
Dan Walters


"DanielWalters6" wrote:

Is there a limit to the number of items you can put in a case statement?

TIA
--
Dan Walters