Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF Statements to Select Case??? | Excel Discussion (Misc queries) | |||
emulating if else Like statements with case | Excel Programming | |||
Using Select Case Statements | Excel Programming | |||
Limits on Case Statements | Excel Programming | |||
Case Statements | Excel Programming |