{"id":3417,"date":"2021-06-19T16:57:50","date_gmt":"2021-06-19T23:57:50","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3417"},"modified":"2021-06-19T16:57:51","modified_gmt":"2021-06-19T23:57:51","slug":"how-to-fix-procedure-too-large-error-in-excel-vba","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3417","title":{"rendered":"How to Fix &#8220;Procedure Too Large&#8221; Error in Excel VBA"},"content":{"rendered":"\n<p>You probably have one or more gigantic procedures\/functions and I think VBA has a limit of 64k or something per procedure.<\/p>\n\n\n\n<p>You fix it by splitting that procedure up into multiple procedures that can then be called by the one procedure.<\/p>\n\n\n\n<p>So instead of having:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> Sub GiantProcedure()\n      ... ' lots and lots of code\n End Sub\n<\/code><\/pre>\n\n\n\n<p>You&#8217;d have something like:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> Sub GiantProcedure()\n      ... ' a little bit of common code\n      Proc1()\n      Proc2()\n      Proc3()\n\n End Sub\n\n Sub Proc1()\n      ... ' quite a bit of code\n End Sub\n\n Sub Proc2()\n      ... ' quite a bit of code\n End Sub\n\n Sub Proc3()\n      ... ' quite a bit of code\n End Sub\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>You probably have one or more gigantic procedures\/functions and I think VBA has a limit of 64k or something per procedure. You fix it by splitting that procedure up into multiple procedures that can then be called by the one procedure. So instead of having: You&#8217;d have something like:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[10,18],"tags":[768,769,770],"class_list":["post-3417","post","type-post","status-publish","format-standard","hentry","category-microsoft","category-microsoft-office","tag-procedure-too-large","tag-procedure-too-large-excel","tag-procedure-too-large-vba"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3417","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3417"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3417\/revisions"}],"predecessor-version":[{"id":3418,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3417\/revisions\/3418"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3417"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3417"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3417"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}