Compile Error Procedure Too Large Excel
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business compile error in hidden module Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation compile error procedure too large excel vba Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like compile error procedure too large vb6 you, helping each other. Join them; it only takes a minute: Sign up Excel VBA Script Compile Error “Procedure too Large” up vote 1 down vote favorite I've spent the whole night doing fruitless "NG" retakes of
Macro Compile Error Procedure Too Large
a long series of Excel VBA scripts, only to encounter repeated issues of Compile Error "Procedure too Large". As such, I would like to share my story and solution, and would also love to hear from you if you have any better ideas. excel vba compilation share|improve this question edited Aug 11 '15 at 14:42 Luuklag 1,231928 asked Oct 29 '13 at 17:11 Pageii Studio 304311 add a comment| 1 Answer 1 active oldest votes up procedure too large vb6 vote 1 down vote accepted I debugged in Visual Basic, and found that by removing the following lines, the problem was resolved: ActiveWindow.ScrollRow = 10 ... ActiveWindow.ScrollRow = 10000 I realised that as my records had more than 10k rows, Macro also captures each of my mousescrolls or keyboard page-down scrolls as an additional macro command all by itself. As such, it choked up the memory limits for the macro due to multiple downward scrolls. So, the problem was resolved by simply deleting all the lines associated with "ActiveWindow.ScrollRow". I guess it would have helped if I had used a newer MS version or a more powerful Mac. Suggestions are welcome on how the Macro recording could have been better done, especially on the need to scroll down to capture deep rows. Do note that I did not select the entire column (by clicking on the column headers) to avoid hitting the max limit of the rows (hence adding unnecessary CPU load ... I guess). What about folks using newer Office like 2013 ... was it worth the upgrade as far as Macros are concerned? share|improve this answer edited Jun 27 at 19:13 answered Oct 29 '13 at 17:11 Pageii Studio 304311 2 True. Then you might find THIS - Point 6 interesting... Even after you have removed unnecessary code lines,, if
Forums Excel Questions Compile Error: procedure too large Page 1 of 2 12 Last Jump to page: Results 1 to 10 of 11 Compile Error: procedure too largeThis is a discussion on Compile Error: vba call another sub procedure too large within the Excel Questions forums, part of the Question Forums category;
How To Call A Function In Vba
I have a huge macro in the "ThisWorkbook" The macro exceeds 64K and I am using SheetChange so I cannot ...
Call Vba
LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode http://stackoverflow.com/questions/19664848/excel-vba-script-compile-error-procedure-too-large Apr 12th, 2012,02:34 PM #1 DillonAlex New Member Join Date Jan 2012 Posts 44 Compile Error: procedure too large I have a huge macro in the "ThisWorkbook" The macro exceeds 64K and I am using SheetChange so I cannot seperate the macro into smaller macros because I need to use "ThisWorkbook" and not any modules What do I do to get around this error. Can I create 2 seperate "ThisWorkbook"? http://www.mrexcel.com/forum/excel-questions/628154-compile-error-procedure-too-large.html Someone please help!!! Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Apr 12th, 2012,02:38 PM #2 Jonmo1 MrExcel MVP Join Date Oct 2006 Location Bryan, TX Posts 41,853 Re: Compile Error: procedure too large I don't uderstand why you can't seperate it out into smaller subroutines...AND store them in standard modules... I have this in the "ThisWorkbook" module Code: Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) test2 End Sub And this in a seperate Standard Module Code: Sub test2() MsgBox "hello" End Sub Works fine. Share Share this post on Digg Del.icio.us Technorati Twitter Add-in for posting ranges as copyable tables (bottom of the page) -Win & Mac The more we learn, and the better we get at our trade, the easier it becomes to overlook the obvious. Life moves pretty fast. If you don't stop and look around once in a while, you could miss it. Ferris Bueller A.K.A. John Hughes, 1986 Reply With Quote Apr 12th, 2012,02:42 PM #3 DillonAlex New Member Join Date Jan 2012 Posts 44 Re: Compile Error: procedure too large The macro is essential this but like over 400 of these Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) 'AUTO-IMMUNE' 'BLOOD DISORDER' If Workshe
be down. Please try the request again. Your cache administrator is webmaster. Generated Wed, 05 Oct 2016 17:16:07 GMT by s_hv997 (squid/3.5.20)