Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 41
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 7,247
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA Compile error: Procedure too large? Jerry Dyben Excel Discussion (Misc queries) 1 October 31st 05 10:15 PM
Compile Error: Procedure too Large Question Daniel R. Young Excel Programming 6 July 21st 05 08:01 PM
Compile error: Procedure too large Susan Hayes Excel Programming 2 May 20th 05 05:01 PM
function "compile error msg: procedure too large" RASHESH Excel Programming 4 May 13th 05 04:48 AM
Compile Error: Procedure too large mate Excel Programming 2 May 18th 04 04:30 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"