Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Trouble figuring out how to Loop through a huge repetitive macro
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="JLGWhiz, post: 6354257"] I finally found it. I knew it was out there somewhere. PRB: Procedure too Large Error When Compiling in VB 4.0 View products that this article applies to. Article ID : 129897 Last Review : December 9, 2003 Revision : 2.0 This article was previously published under Q129897 SYMPTOMS Some procedures that compile in Visual Basic version 3.0 generate the following compile-time error message in Visual Basic version 4.0: Procedure too large Back to the top CAUSE The maximum size of the internal code for an individual procedure in Visual Basic version 3.0 is 64K bytes. Microsoft Visual Basic version 4.0 for Windows uses Microsoft Visual Basic for Applications, which generates more generic internal code than does Microsoft Visual Basic version 3.0. This generic code allows for compatibility with a wider range of processors. This makes the internal code larger, so it can cause very large procedures to exceed the 64K limit and fail to compile. Back to the top WORKAROUND Split the large procedure into two or more smaller procedures. Back to the top STATUS This behavior is by design. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Trouble figuring out how to Loop through a huge repetitive macro
Top