Excel VBA: Procedure too large - doomed?

[yky]

I received a "procedure too large" error which, according to web search result, can be solved by splitting codes into smaller subroutines. In my case, I don't know how to do it.

My error occurs in "select case". I have more than 200 cases to process. Any idea how to split cases into smaller unit?

 

[yky]

Thank you, Denis. That is exactly the same way I used to write the case codes. I have the categories from Quicken in one column, next to it is the categories in the report. I manually assign a report category to each Quicken category. On the further right column, I use the concatenate function to write codes.

The problem is assigning the category (in your example, it would be bird, mammal, etc) is done manually. If it is done programmatically, then, again, I'll face this 200+ case situation (I'd have codes like case cat insert "mammal" to the right. Something like that.) Or is there a way around it?