Procedure too large

[Tommi]

Hello!
When trying run a macro I get "Procedure Too Large"
Is there some kind of limit, how large procedure can be?
Is there is, could someone help me, and please tell how large procedure can
be.

Do you have any suggestions what I should do with my procedure: it contains
quite large If, for -structures

Best Regards,
Tommi Kujanpää

 

[Dick Kusleika]

Tommi

I don't know what the limit is and I can't find anything that tell me.

If you're getting that error, you just need to break the procedure into
smaller ones. Instead of a big If.Then construct, put that into a function
that returns the value you want. It's hard to be more specific without
seeing your code.

 

[Bob Umlas]

The limit is APPROXIMATELY 5000 lines of code in one procedure.

 

[Dick Kusleika]

Thanks Bob

Dick

The limit is APPROXIMATELY 5000 lines of code in one procedure.