Sub is to long have to make another how do i make it start where it left off?

[OldGreg]

My First Macro/Sub is really long, So i divided it into 2. But how can i make the second Macro run right after the first?

 

[pbt]

What you are looking for is Calling a Macro From Within a Macro

Hopefully you have named the 2 macros with different names. So before the End Sub statement of the 1st macro put his line in

Call (name of you 2nd Macro)

You really don't need to put the word "Call". You can just put the name of your 2nd Macro.

If you want to post your "too long" code here, maybe somebody can shorten it for you. Just be sure to post between

 tags.  Use the # icon in the advanced features of the reply window.

 

[OldGreg]

 I was curious how to do that. Thank you

Cool ill shorten it when im fully complete. Im very positive it could use some shortning.