Referencing a task outside of a sub then continuing within the original sub

[Maxwelll]

I am running into a situation that I have multiple subs that overall do different things but a portion of them do the same thing. The issue is if I find I must change that code, I have to go to 5 different subs to make the change.

Is there a way I can write a task of some sort that I can just reference but my specific sub continues on? This way I will only have to change 1 location.


Here is an example...

Please Login or Register  to view this content.

I am not sure if I explained this right but thank you!

Max

[gjw1971]

This should really be in the VBA section of this forum; hopefully a mod will move it to its correct place for you.

To reference a sub, all you need to do is to create a new one, containing the parts that you want to reference, e.g.

Please Login or Register  to view this content.

Then in your subs that you want to call this, just add the line:

Please Login or Register  to view this content.

[Maxwelll]

Sorry I didn't notice that prior to posting.

The problem with that is that as soon as the new sub test ends, the vba stops. I want it to return to the origional sub and continue on.

[gjw1971]

If you call the Test sub from within another sub, it should just run the Test sub, then continue back I. Your original sub.
Have you tried stepping through the code, using F8, to see at what point it stops?

[Maxwelll]

Yes you are correct. I have to go back to one of my other sheets and figure out why I could not get it to work. Thank you for pointing this out to me.