"end sub" error

[Vee]

I have written a macro that has been used multiple times without error. The
macro calls several macros. The first macro is executing properly but then
stops/errors on the "end sub" and does not continue with the remaining macros.

 

[Don Guillett]

As always, post YOUR code for comments. No mind readers here.

 

[Rick Rothstein]

As Don said, post your code so we can see what you are working with.
However, I would note that if you have other code to execute, you should not
be running into the "End Sub" statement (there should only be one "End Sub"
statement and it should be the final line in your subroutine). If you have
it duplicated elsewhere in your code, perhaps you meant to use "Exit Sub"
instead.

 

[JLGWhiz]

Hi Rick, I believe that if the main macro is calling other macros then there
will be more than one "End Sub" statement. Again, without the OP posting
their code, it is difficult to guess what the problem might be.

 

[Rick Rothstein]

Can you post an example of what you mean?