How do I separate a Macro into two parts?

[arthurz11]

I created a macro (Ctrl-N). When I executed the macro, I got a message error Procedure Too Long. How can I separate it or split it into two parts so that it will work? In other words, I can cut out half of the code and then paste it somewhere else (not sure where), but it will still work using the Ctrl-N.

 

[johnnyL]

Create another subroutine called Part2 for example. Cut the lower portion of code from the original subroutine and paste it into the new subroutine that you created. At the bottom of the original subroutine add the following line of code Call Part2

So you will end up with something like the following:

Sub Original()
' First half of code
    Call Part2
End Sub

Sub Part2()
' Last half of code
End Sub

This may create issues with variable names that you will have to handle.

You may want to see if you can just shorten your current code

 

[arthurz11]

Create another subroutine called Part2 for example. Cut the lower portion of code from the original subroutine and paste it into the new subroutine that you created. At the bottom of the original subroutine add the following line of code Call Part2

So you will end up with something like the following:

Sub Original()
' First half of code
    Call Part2
End Sub

Sub Part2()
' Last half of code
End Sub

This may create issues with variable names that you will have to handle.

You may want to see if you can just shorten your current code

I will give it a try.

 

[arthurz11]

I will give it a try.

It worked!! Thank you kindly for your help.

 

[johnnyL]

Glad to help.