Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
"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
|
|||
|
|||
![]()
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
|
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |