Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error: Procedure too large
"Compile Error: Procedure too large"
Any ways to circumvent this by tweaking any Excel settings, or do i have to rightsize up my macro? TIA!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error: Procedure too large
Never had this error, but 'right-sizing' sounds the solution to me, there
are problems when modules get too big, so the same would apply to a procedure. -- HTH RP (remove nothere from the email address if mailing direct) "BHARATH RAJAMANI" wrote in message ... "Compile Error: Procedure too large" Any ways to circumvent this by tweaking any Excel settings, or do i have to rightsize up my macro? TIA!! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error: Procedure too large
You need to break the procedure in to parts. Good structured
programming usually prevents this error from occurring in the first place. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "BHARATH RAJAMANI" wrote in message ... "Compile Error: Procedure too large" Any ways to circumvent this by tweaking any Excel settings, or do i have to rightsize up my macro? TIA!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Compile error: Procedure too large? | Excel Discussion (Misc queries) | |||
Compile Error: Procedure too Large Question | Excel Programming | |||
Compile error: Procedure too large | Excel Programming | |||
function "compile error msg: procedure too large" | Excel Programming | |||
Compile Error: Procedure too large | Excel Programming |