procedure too large

  1. D

    VBA procedure too large

    hi Guys, I have a huge worksheet with a lot of code in it, but everytime i run it, it gives me an error saying the procedure is too large. Is there a work around it? the code is 4000 lines, but most of it is the same thing with the only difference being either the table name, column name, or...
  2. C

    Procedure Too Large

    I have simple but long code as below. I am getting error saying that "Procedure too large". Can someone tell me how to make it shorter or split it? Appreciate and thanks in advance. Option Explicit Private Sub cmdCancel_Click() Unload Me End Sub Private Sub cmdOK_Click() Dim LColumn As...
  3. C

    Compile error

    When running my macro I received a compile error stating the procedure is too large. Does this error mean there are too many formulas for this macro? How do I fix it?
  4. A

    VBA Select Case error: procedure too large

    Hi, I have 30 different cases working well in one module so far. Now I need to add some more cases, but the system doesn’t allow me to start defining any new cases under Select – Case, it shows: compile error: procedure too large. I’m thinking maybe there’s a way to combine multiple cases...
  5. C

    Procedure Too Large - I know I should condense it, but I don't know how...

    Hi there Excel Wizards, I wonder if you can help me with a problem I'm having. I'm creating a heat map in Excel, and after many months of struggle I've managed to source the code. When I've put it together in VBA (of which my knowledge is zero), I get a Procedure Too Large message. I've...
  6. S

    Macro procedure too large.... how can I shorten?

    My spreadsheet has a specific macro embedded in it that I want to run many times (the command sets several items in the current row on spreadsheet, and then jumps to next row). I set up my own macro to run the command many times in succession (for many rows). It sets calculation to Manual...
  7. Y

    Excel VBA: Procedure too large - doomed?

    I received a "procedure too large" error which, according to web search result, can be solved by splitting codes into smaller subroutines. In my case, I don't know how to do it. My error occurs in "select case". I have more than 200 cases to process. Any idea how to split cases into smaller unit?
  8. I

    Procedure Declarations Equal to Initialize and Activate

    :confused:What is a procedure that acts the same as Userform_Initialize() and Userform_Activate()? I have tried typing my own as Userform_Initialize2() but it does not work. I just need another procedure that will run when the form is opened other than those 2. Please help. imav
  9. N

    Procedure too large - how can I shorten my code?

    I have written a macro to work from an command button to update sales reports. This command button will update the master sheet, then create, rename and save etc individual files to be emailed out to the sales guys. The code is now too long as I am still quite new to using visual basic I do...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top