Procedure Too Large

vba error-handling ms-office

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:

 Sub GiantProcedure()      ... ' lots and lots of code End Sub

You'd have something like:

 Sub GiantProcedure()      ... ' a little bit of common code      Proc1()      Proc2()      Proc3() End Sub Sub Proc1()      ... ' quite a bit of code End Sub Sub Proc2()      ... ' quite a bit of code End Sub Sub Proc3()      ... ' quite a bit of code End Sub

vba error-handling ms-office

Your compiled procedure cannot exceed 64kb. You should break it up into different sub routines.

http://msdn.microsoft.com/en-us/library/Aa264541

vba error-handling ms-office

You might get this error message if the macro has been created using the 64-bit version of Office. See the following article for further details and a workaround:

"Compile Error: Procedure too large" error message when you try to run a VBA macro in a 32-bit version of an Office 2010 program

CodeHunter

Procedure Too Large

Recent Posts

How can I color dots in a xy scatterplot according to column value?

How to update a claim in ASP.NET Identity?

What does {0} mean when initializing an object?

Accessing members of items in a JSONArray with Java

How to log SQL statements in Spring Boot?

Powershell Get-WebSite name parameter is ignored

How to detect scroll to bottom of html element

Java synchronized method

How to test controllers with CodeIgniter?

Detect Visual Composer

Matplotlib: Specify format of floats for tick labels

Rails join a list of strings with commas and "and" before the last