Procedure too large

  • Article

This page is specific to the Visual Basic for Applications (VBA) Language Reference for Office 2010.

When compiled, the code for a procedure can't exceed 64K. This error has the following cause and solution:

  • Code for this procedure exceeds 64K when compiled. Break this, and any other large procedures, into two or more smaller procedures.

For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).