Procedure too large error

I'm getting this error when I try to run my code. I know it's possible to do it with "For", but I don't know how, once the conditions are words instead of a sequence of numbers.

Ps: Janeiro = January (it's in portuguese)

Please Login or Register  to view this content.

Hi luizmachado,

I don't think there is anything wrong with your code. The problem is that you are trying to fit ten pounds of code into a five pound capacity Excel VBA module.

You probably have to put the code into two or more Excel Code Modules.

For Example:
In Code Module1:

Please Login or Register  to view this content.

In Code Module2:

Please Login or Register  to view this content.

I hope this helps.

Lewis

Thank you Lewis and Norie!! Both of yours solutions worked!! Thank youu =)