Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure too large
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 procedu it contains quite large If, for -structures Best Regards, Tommi Kujanpää |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure too large
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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Tommi" wrote in message ... 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 procedu it contains quite large If, for -structures Best Regards, Tommi Kujanpää |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure too large
The limit is APPROXIMATELY 5000 lines of code in one procedure.
"Dick Kusleika" wrote in message ... 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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Tommi" wrote in message ... 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 procedu it contains quite large If, for -structures Best Regards, Tommi Kujanpää |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Procedure too large
Thanks Bob
Dick "Bob Umlas" wrote in message ... The limit is APPROXIMATELY 5000 lines of code in one procedure. "Dick Kusleika" wrote in message ... 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. -- Dick Kusleika MVP - Excel www.dicks-clicks.com Post all replies to the newsgroup. "Tommi" wrote in message ... 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 procedu it contains quite large If, for -structures Best Regards, Tommi Kujanpää |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop a Procedure from another procedure | Excel Discussion (Misc queries) | |||
VBA Compile error: Procedure too large? | Excel Discussion (Misc queries) | |||
procedure too large | Excel Programming | |||
Procedure Too Large problems | Excel Programming |