VBA - Procedure too large!

[colinmel]

<TABLE style="WIDTH: 248pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=328 border=0 x:str><COLGROUP><COL style="WIDTH: 31pt; mso-width-source: userset; mso-width-alt: 1499" span=8 width=41><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD class=xl24 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; WIDTH: 248pt; BORDER-BOTTOM: #ece9d8; HEIGHT: 25.5pt; BACKGROUND-COLOR: transparent" width=328 colSpan=8 height=34 rowSpan=2>I ran my Macro, which is quite long, and got the error message "PROCEDURE TOO LARGE"

Is there any way to split the VBA into 2 so that it runs?
</TD></TR><TR style="HEIGHT: 12.75pt" height=17></TR><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; HEIGHT: 12.75pt; BACKGROUND-COLOR: transparent" height=17></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; BORDER-LEFT: #ece9d8; BORDER-BOTTOM: #ece9d8; BACKGROUND-COLOR: transparent"></TD></TR></TBODY></TABLE>

 

[villy]

I suggest split it into several functions then call it one by one...

 

[colinmel]

I suggest split it into several functions then call it one by one...

Sorry about this, but I'm actually a bit of a novice, so excuse my ignorance, but i don't know what you mean when you say to split it into several functions?

 

[colinmel]

any ideas?

 

[villy]

What's the name of your Macro?

 

[Norie]

You can split the code up but it might be worth taking a look at what you currently have.

You never know it might be able to tidy it up or shorten it.

If you are going to split it up you might want to identify sections of the code that do particular things.

Then you can create new subs, in new modules and call them like this:

Sub Main()

      Call SubA 
      Call SubB
      Call SubC

End Sub

Where SubA, B... etc are subs where you've put the code you split out.

 

[colinmel]

It says "Compile Error - Procedure too large"

I've just called my macro - test1, does it make a difference?

For the Sub A, B and C, where do I put the actually code that I will split?

 

[Norie]

Can you post a sample of the code?

 

[Tejdeep]

Hi,

I have got the same issue, Can place all code in a text file and real one line at a time and execute it?

Any help will be appreciated.

Regards,
Tej

 

[Norie]

No you can't do that.

What you should do is go through the code and try and tidy it up.