"end sub" error
 

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.

"end sub" error
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Vee" wrote in message
...
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.

"end sub" error
 

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.

--
Rick (MVP - Excel)


"Vee" wrote in message
...
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.

"end sub" error
 

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" wrote:

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.

--
Rick (MVP - Excel)


"Vee" wrote in message
...
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.

"end sub" error
 

Can you post an example of what you mean?

--
Rick (MVP - Excel)


"JLGWhiz" wrote in message
...
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" wrote:

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.

--
Rick (MVP - Excel)


"Vee" wrote in message
...
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.